LINQ Where condition against datatable

Question

I have a DataTable. I would like to filter DataRows where City = "Hongkong".

How to apply LINQ against DataRow?

user2488066 · Accepted Answer · 2013-06-15 18:01:40Z

2

You could use the following Query

var filter = testTable.AsEnumerable().
                       Where(x => x.Field<string>("City") == "HongKong");

answered Jun 15, 2013 at 18:01

user2488066

Sign up to request clarification or add additional context in comments.

Comments

Hogan · Accepted Answer · 2013-06-15 18:07:26Z

1

 var result = dr.Where(r => r.Field<string>("City") == "Hongkong");

answered Jun 15, 2013 at 18:00

Hogan

70.7k10 gold badges82 silver badges119 bronze badges

Steven · Accepted Answer · 2013-06-15 18:02:39Z

0

Using LINQ to DataSets, you can do the following:

DataTable table;

var rows =
    from row in table.AsEnumerable()
    where row.Field<string>("City") == "Hongkong"
    select row;

answered Jun 15, 2013 at 18:02

Steven

174k25 gold badges355 silver badges453 bronze badges