Selecting Data from DataSet:
Do include namespace: using Syste.Data.DataSetExtensions;
var cars = from car in MyDataSet.AsEnumerable()
where
(int)car["CarID"] > 5
select
new
{
ID
= (int)car["CarID"],
Color
= (string)car["Color"]
};
Using DataRowExtensions.Field<T>():
var cars = from
car in MyDataSet.AsEnumerable()
where
car.Field<int>("CarID") > 5
select
new
{
ID = car.Field<int>("CarID"), Color =
car.Field<string>("Color") };
