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" ]);