DataGrid的双项排序

 1//* 把aspx页中的DataGrid的AllowSorting="True"//
 2
 3private void Page_Load(object sender, System.EventArgs e)
 4{
 5if(!Page.IsPostBack)
 6{
 7                
 8ViewState["SortExpression"]="";//排序的字段名如"FristName",现在为空;
 9ViewState["sort"]="desc";//排序的默认先为DESC
10databind();//绑定数据
11}
12}
13
14//*读取数据绑定DataTableGrid_AdvanceSearch控件*//
15private void databind()
16{
17CompanyDA DA = new CompanyDA();//调用数据类
DataTable dt = DA.GetTable("Select * From V_ContactList");//读取数据返回
DataTableGrid_AdvanceSearch.DataSource = dt.DefaultView;
18Grid_AdvanceSearch.DataBind();
19ViewState["table"] = dt;
20}
21
22//对数据进行排序//
23private void Grid_AdvanceSearch_SortCommand(object source,System.Web.UI.WebControls.DataGridSortCommandEventArgs  e)
24{
25string sort=string.Empty;
26if(ViewState["SortExpression"].ToString()==e.SortExpression.ToString())
27{
28if(ViewState["sort"].ToString()=="asc")
29{sort="desc";}
30else{sort="asc";}
31}
32else
33{
34if(ViewState["sort"].ToString()=="asc")
35{sort="desc";}
36else
37{sort="asc";}
38}
39    
40DataTable dt =(DataTable)ViewState["table"];
41ViewState["sort"]=sort;
42ViewState["SortExpression"]= e.SortExpression;
43DataView dv = new DataView();
44dv = dt.DefaultView;
45dv.Sort=ViewState["SortExpression"]+" "+ViewState["sort"]; //指定视图的排序方式;
46Grid_AdvanceSearch.DataSource = dv;
47Grid_AdvanceSearch.DataBind();
48}
49
50