DataSet ds = db.ExecuteSqlDs(sqlstr);
DataView dataview = ds.Tables[0].DefaultView;
if (sort != "")
dataview.Sort = sort;
protected void DataGrid1_SortCommand(object source, DataGridSortCommandEventArgs e)
{
if (ViewState["order"].ToString().ToUpper() == " DESC")
ViewState["order"] = " ASC";
else
ViewState["order"] = " DESC";
if (e.SortExpression == "isCompleteBusinessLicense")
ViewState["sort"] = "isCompleteBusinessLicense" + ViewState["order"].ToString() + ",isCompleteTaxRegistration" + ViewState["order"].ToString() + ",isCompleteFoodHygiene" + ViewState["order"].ToString() + ",isCompleteCorporateCode" + ViewState["order"].ToString() + ",isCompleteAccountLicence" + ViewState["order"].ToString();
else
ViewState["sort"] = e.SortExpression + ViewState["order"].ToString();
bindDG(ViewState["sort"].ToString());
}
<asp:DataGrid id="DataGrid1" Width="100%" DataKeyField="id" runat="server" AutoGenerateColumns="False"
BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" BackColor="White" CellPadding="3" AllowPaging="True"
PageSize="20" onsortcommand="DataGrid1_SortCommand" AllowSorting="True" >
</asp:DataGrid>