Add multiple Where condition in Linq query using C# and VB.Net

Last Reply 6 months ago By pandeyism

Posted 6 months ago

Compare Two DataTables and copy Rows in Third DataTable with status using C# and VB.Net

i have asked qus few days ago. i got solution but now i have to change the condition, i have to include and operator with more filters. so please let me know, how i can add other filters with Department. Just assume i have to check with department and name and marks. 

List<DataRow> rows = dt2.AsEnumerable()
                     .Where(x => !dt1.AsEnumerable()
                     .Select(y => y.Field<string>("Department"))
                     .Contains(x.Field<string>("Department"))).ToList();
You are viewing reply posted by: pandeyism 6 months ago.