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();