from sql to div with linq asp.net web forms

Question

I'm trying to retrieve information from ms sql server to my div.

<div id="blablablaText" runat="server">
                    ...
                </div>

and here's my source code

 protected void Page_Load(object sender, EventArgs e)
    {
        using (myDbDataContext wdb = new myDbDataContext ())
        {
            Article ar = new Article();

            var a = from p in wdb.Articles
                    where p.Id == 16
                    select p.Text;



            blablablaText.InnerText = a.ToString();
        }
    }

after that my output is:

SELECT [t0].[Text] FROM [dbo].[Article] AS [t0] WHERE [t0].[Id] = @p0

what am I doing wrong?

try a.First() instead of a.ToString().

tschmit
– tschmit

2014-07-03 09:57:03 +00:00
Commented Jul 3, 2014 at 9:57 — tschmit
– tschmit, Commented Jul 3, 2014 at 9:57
@George First() is not the right way of doing it

Arijit Mukherjee
– Arijit Mukherjee

2014-07-03 10:00:38 +00:00
Commented Jul 3, 2014 at 10:00 — Arijit Mukherjee
– Arijit Mukherjee, Commented Jul 3, 2014 at 10:00

jjaskulowski · Accepted Answer · 2014-07-03 09:57:48Z

1

You want to execute .First() on that instead of .ToString();

a is a query. First() will execute it and return the value of first row of the executed sql select statement. As you selected only one string column a will already be the string you want.

Beware. First() must find at least one row or it will throw an exception. If you want to get null in the worst case scenario then you should use FirstOrDefault().

answered Jul 3, 2014 at 9:57

jjaskulowski

2,6044 gold badges29 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kiran Hegde · Accepted Answer · 2014-07-03 09:59:25Z

0

You have to to get the first or firstordefault before converting to string

using (myDbDataContext wdb = new myDbDataContext ())
        {
            Article ar = new Article();

            var a = from p in wdb.Articles
                    where p.Id == 16
                    select p.Text;



            blablablaText.InnerText = a.First().ToString();
        }

answered Jul 3, 2014 at 9:59

Kiran Hegde

3,6811 gold badge18 silver badges14 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 10:32:22Z

0

using (myDbDataContext wdb = new myDbDataContext ())
    {
        Article ar = new Article();

        var a = (from p in wdb.Articles
                where p.Id == 16
                select p.Text).FirstorDefault();



        blablablaText.InnerText = a.ToString();
    }

Your should be using FirstorDefault() instead of First(); as If there is nothing in your variable a then First will throw an exception where as FirstorDefault will set it to null/empty.

First VS FirstorDefault

edited May 23, 2017 at 10:32

CommunityBot

11 silver badge

answered Jul 3, 2014 at 10:01

Arijit Mukherjee

3,8952 gold badges36 silver badges53 bronze badges

Collectives™ on Stack Overflow

from sql to div with linq asp.net web forms

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related