SQL query related...

Try this

Put [ before column name and ] after column name.

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