SQL query related...

I don't have idea about linq but you achive it using dt.Select as

string id;
string dtDate;

DataRow[] maxRow = dt.Select("Column1 = MAX(Column1)");

If (maxRow.Length > 0)
{
id = maxRow[0]["Column1"].ToString();
dtDate = maxRow[0]["Column2"].ToString();
}

---

Ashish Pandey