GridView排序

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>
posted @ 2011-04-06 14:21  xfyn  阅读(178)  评论(0编辑  收藏  举报