DataTable.Select() not working

Question

In my datatable I have two rows with multiple columns.

One of the columns are ItemID and their values are 2215,2216.

When I use the following statement:

Click to copy

DataRow[] dr = dt.Select("ItemID='2215'");

It returns both rows. It's not filtering.

What I am missing?

Answer 1

This should work if your table has data with the structure you described.

Click to copy

var dr = from row in dt.AsEnumerable()
    where row.Field<int>("ItemID") == 2215
    select row;

DataTable dtSelected = dr.CopyToDataTable();

Answer 2

Try like this

Click to copy

DataRow[] dr = dt.Select("ItemID=2215");