Tuesday, 13 January 2015

Asp.net sorting DataTable row in ascending or descending order by DefaultView

Ascending  

DataTable table = "Query to get DataTable from database";
      table.DefaultView.Sort = "FieldName ASC";
      repeater1.DataSource = table.DefaultView;
      repeater1.DataBind();

Descending  

DataTable table = "Query to get DataTable from database";
      table.DefaultView.Sort = "FieldName DESC";
      repeater1.DataSource = table.DefaultView;
      repeater1.DataBind();

No comments:

Post a Comment