Let's say we have a DataTable in which their is a column of age. We need to select the person whose age is the older one. The below code will do
public DataTable GetData()
{
DataTable dt = new DataTable();
//Add some columns
dt.Columns.Add(new DataColumn("Age", typeof(Int32)));
//Add some rows
//First Row
DataRow row1 = dt.NewRow();
row1("Age") = 21;
//Second Row
DataRow row2 = dt.NewRow();
row2("Age") = 11;
//Third Row
DataRow row3 = dt.NewRow();
row3("Age") = 12;
//Fourth Row
DataRow row4 = dt.NewRow();
row4("Age") = 55;
//Fifth Row
DataRow row5 = dt.NewRow();
row5("Age") = 18;
//Add the rows to the table
dt.Rows.Add(row1);
dt.Rows.Add(row2);
dt.Rows.Add(row3);
dt.Rows.Add(row4);
dt.Rows.Add(row5);
//return the table
return dt;
}
Then filter as under
var oldestRecord = GetData().AsEnumerable().Select(dr=>dr["Age"]).Max();