Linq-to-SQL question

Question

im really new to linq-to-SQL so this may sound like a really dumb question, i have the following code

    var query = from p in DC.General
                where p.GeneralID == Int32.Parse(row.Cells[1].Text)
                select new
                {
                    p.Comment,
                };

how do i got about getting the result from this query to show in a text box ??

I would highly recommend getting LINQPad, where you can see the results and the actual query sent. It's a great "scratchpad" for working out Linq queries and free. linqpad.net — Steve
– Steve, Commented Mar 28, 2010 at 14:05

Prutswonder · Accepted Answer · 2010-03-28 13:41:13Z

1

That would be:

TextBox1.Text = query.Single().Comment;

You have to filter the first result from your query. To do that, you can use Single() if you know the query only returns one value. You could also use First(), if the results might contain more than one row.

Also, if it's only a single value, you could rewrite the code to:

var query = from p in DC.General
            where p.GeneralID == Int32.Parse(row.Cells[1].Text)
            select p.Comment;

TextBox1.Text = query.Single();

answered Mar 28, 2010 at 13:41

Prutswonder

10.1k3 gold badges29 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

Linq-to-SQL question

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related