query datatable

Use a DataView to query a DataTable or you can use LINQ.

//LINQ Example
DataRow row = customers.AsEnumerable()
.Where(i => i.Field("CustID") == 4)
.FirstOrDefault();

//LINQ - Strongly Typed DataSet
DataRow row = ds.Customers.AsEnumerable()
.Where(i => i.CustID == 4)
.FirstOrDefault();

//DataTable Example
DataRow row = customers.Select("CustID = 4")[0];

//DataView Example
DataView dv = new DataView(customers);
dv.RowFilter = "CustID = 4";