How To Set Date in gridview Asceinding Order

Hello Sandeep,

Try Below code to sort database columns.

dt.DefaultView.Sort = "sortColumn"; 
dt = dt.DefaultView.ToTable();
grvChemicalReport.DataSource = dt;
grvChemicalReport.DataBind();

Thanks

Aspx page

To  Bind Gridview

DataTable dt = Water.GetChemicalReceiptConsumptionDateWiseSummary(txtFromDate.Text, txtToDate.Text); 
grvChemicalReport.DataSource = dt;
grvChemicalReport.DataBind();

Hello Sandeep,

Please try below code sample with you dataset to get the expected result.
 

var orderedData = dataList.OrderBy(x => x.Date).ToList();
GridView1.DataSource = ds;
GridView1.DataBind();

Thanks