Compare DataRow collection to List<T>

c# linq c#-3.0 datatable datarow
Jon picture Jon · Jan 5, 2010 · Viewed 13.7k times · Source

I have a List<string> and I have a DataTable.

One of the columns in a DataRow is ID. The List holds instances of this ID.

The DataTable gets populated on a Timer.

I want to return items from the List that are not in the DataTable into another list.

Answer

bdowden picture bdowden · Jan 5, 2010

You will want to do something like this

var tableIds = table.Rows.Cast<DataRow>().Select(row => row["ID"].ToString());

var listIds = new List<string> {"1", "2", "3"};

return listIds.Except(tableIds).ToList();

You can cast the rows in the data table to be an IEnumerable collection and then select the "ID" column value from each of them. You can then use the Enumerable.Except extension method to get all of the values from the List that are not in the collection you just made.

If you need to get the values that are in the table but not the list, just reverse listIds and tableIds.

Related questions

How to get index using LINQ?

Given a datasource like that: var c = new Car[] { new Car{ Color="Blue", Price=28000}, new Car{ Color="Red", Price=54000}, new Car{ Color="Pink", Price=9999}, // .. }; How can I find the index of the first car satisfying a certain condition with LINQ? …

Read More
Favorite way to create an new IEnumerable<T> sequence from a single value?

I usually create a sequence from a single value using array syntax, like this: IEnumerable<string> sequence = new string[] { "abc" }; Or using a new List. I'd like to hear if anyone has a more expressive way to do …

Read More
LINQ - selecting second item in IEnumerable

I have string[] pkgratio= "1:2:6".Split(':'); var items = pkgratio.OrderByDescending(x => x); I want to select the middle value and have come up with this. Is this a correct way to select the second value in an IEnumberable? …

Read More