I need to compare a list with Datatable and filter values using Linq

Question

I need to compare a list against a Datatable column and return the result as values from the list that are not present in the DataTable.

List:

DataTable:

Here I need to compare the list against the Datable User Id column and return the result from the list not present in the DataTable.

For example IMS022 and IMS029 are present in the list and not present in Datable.Hence I have to get IMS022, IMS029 as filter result

Thank you in advance

+3

Arun D Apr 25. 17 at 5:39 am

2 answers

var result=Items.Except(datatable.AsEnumerable().Select(r => r.UserID<string>(columnIndex)));

Hope it helps!

0

mounika Apr 25. 17 at 6:07

Nikhil Agrawal · Accepted Answer · 2017-04-25T05:42:43+0000

You can do

var result = list.Except(dataTable.AsEnumerable().Select(x => x["User Id"]));

You need to import the namespace System.Linq

to use Except

.

I need to compare a list with Datatable and filter values ​​using Linq