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, Jul 26 '13 at 09:34
yes i have added System.Linq And i tried using DataSet but it doesnt work at all — Pratik, Jul 26 '13 at 09:35
Possible duplicate: http://stackoverflow.com/questions/10855/linq-query-on-a-datatable — thmshd, Jul 26 '13 at 09:35

score 1 · Answer 1 · answered Jul 26 '13 at 09:38

1

You should iterate rows to achive it

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

answered Jul 26 '13 at 09:38

Viacheslav Smityukh

5,652
4
24
42

score 0 · Answer 2 · answered Jul 26 '13 at 09:34

0

Hope this can help you.

LINQ to DataSet

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

answered Jul 26 '13 at 09:34

Mico

117
1
12

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? – Pratik Jul 26 '13 at 09:46
Check this 3.5 version http://msdn.microsoft.com/en-us/library/bb386921%28v=vs.90%29.aspx – Mico Jul 26 '13 at 10:01

score 0 · Answer 3 · answered Jul 26 '13 at 09:35

0

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

answered Jul 26 '13 at 09:35

Bart

29
4

linq with dataTable in c#

3 Answers3