Datatable asEnumerable

Question

Hi
var filtered = dt0.AsEnumerable()
.Where(r => r.Field ("Id").Contains(col[2].ToString()));
I want Id value to be saved in Datatable of those records where Id matches col[2]
Thanks

Jignesh Kumar · Answer

Hi Jagjit,  You can use linq to filter records and get Ids matching with your 2nd column. You can use string.join() function to make it comma seperated string and then you can store comma seperated values to database if you wish to store, string  Ids =  "" ;   var filtered = myDataTable.AsEnumerable()   .Where(r => r.Field ( "ID" ).Contains(Convert.ToString(col[ "ID" ])));   if  (filtered.FirstOrDefault() !=  null )   Ids += String.Join( "," , filtered.Select(a => a.Field ( "ID" )));

Gajendra Jangid · Answer

var filtered = myDataTable.AsEnumerable()                             .Where(r => r.Field ( "ID" ).Contains(Convert.ToString(col[ "ID" ])));          if  (filtered.FirstOrDefault() !=  null )             ID = Convert.ToString(filtered.FirstOrDefault()[ "ID" ]);

Muhammad Imran Ansari · Answer

If filtered returning more than 1 records than use te following code: string  IDs =  "" ;   foreach  (DataRow col  in  dt.Rows)   {           var filtered = myDataTable.AsEnumerable()                           .Where(r => r.Field ( "ID" ).Contains(Convert.ToString(col[ "ID" ])));               if  (filtered.FirstOrDefault() !=  null )                   IDs += String.Join( "," , filtered.Select(a => a.Field ( "ID" )));   }      // IDs variable will have all matched ID

Jagjit Saini · Answer

Hi Muhammad     If filtered returns more than 1 record   Thanks

Muhammad Imran Ansari · Answer

Use the followinf code to get ID of filtered record. var filtered = myDataTable.AsEnumerable()                           .Where(r => r.Field ( "ID" ).Contains(Convert.ToString(col[ "ID" ])));      if  (filtered.FirstOrDefault() !=  null )           ID = Convert.ToString(filtered.FirstOrDefault()[ "ID" ]);