You can achieve that using
Linq To Dataset[
^].
var result = ds.Tables(0).AsEnumerable()
.Where(r=>r.Fields<int>("MenuSubCategoryId")==1);
or:
var result = ds.Tables(0).AsEnumerable()
.Select(r=>r.Field<int>("MenuSubCategoryId"));
foreach(var r in result)
{
Console.WriteLine("{0}", r.Field<int>("MenuSubCategoryId"));
}
or:
var result = ds.Tables(0).AsEnumerable()
.FirstOrDefault(r=>r.Fields<int>("MenuSubCategoryId"));
For further information, please see:
LINQ to DataSet Examples[
^]
Queries in LINQ to DataSet[
^]
Querying DataSets (LINQ to DataSet)[
^]