linq with dataTable in c#

Question

I am using datatable on which I want to use Linq. but as i am new to linq i dont know how it uses. I google it I got lots of information which is not sufficient like. If I am using datatable and i got info like :

DataRow r = from dr in ds.Tables["Customers"].AsEnumerable() where dr.Field<Guid>("customerid").ToString() = row[2].ToString() select dr; dt.ImportRow(r);

and I have lots of queries like what is "dr". dr.fields?, ".AsEnumerable()" is not present at my side.

Even this code also doesnt work:

IEnumerable<DataRow> r = from dr in ds.Tables["Customers"].Select().Where(x => x.Field<Guid>("customerid").ToString() == row[2].ToString()) select dr;

So can anyone please give me link on which i got all information from beggining on linq.

You need to add a reference to System.Data.DataSetExtensions.dll and make sure you have a using System.Data; directive in your file. — Lee
– Lee, Commented Jul 26, 2013 at 9:34
yes i have added System.Linq And i tried using DataSet but it doesnt work at all — Pratik
– Pratik, Commented Jul 26, 2013 at 9:35
Possible duplicate: stackoverflow.com/questions/10855/linq-query-on-a-datatable — thmshd
– thmshd, Commented Jul 26, 2013 at 9:35

Viacheslav Smityukh · Accepted Answer · 2013-07-26 09:38:02Z

You should iterate rows to achive it

var r = ds.Tables["Customers"].Rows .Cast<DataRow>() .Where(r => r["fieldName"].ToString() == "Test");

Mico · Accepted Answer · 2013-07-26 09:34:27Z

0

Hope this can help you.

LINQ to DataSet

http://msdn.microsoft.com/en-us/library/bb386921.aspx

answered Jul 26, 2013 at 9:34

Mico

1171 silver badge12 bronze badges

2 Comments

Pratik Over a year ago

As per this link it is not working at my end means DataTable.AsEnumerable() is not appearing at my end(Framework 3.5) What is exact issue?

Mico Over a year ago

Check this 3.5 version msdn.microsoft.com/en-us/library/bb386921%28v=vs.90%29.aspx

Bart · Accepted Answer · 2013-07-26 09:35:27Z

It's like a SQL select query, where dr is the * (that is, it is the returned data).

Some nice examples: http://code.msdn.microsoft.com/101-LINQ-Samples-3fb9811b

Collectives™ on Stack Overflow

linq with dataTable in c#

3 Answers 3

Comments

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Linked

Related