对gridview进行排序

  gridview如果使用sqldatasource绑定数据集的话分页只需将gridview 属性设置为 AllowSorting="True" 即可，但是如果采用其它数据源绑定属性 AutoGenerateColumns  如果设置为false 那么上面的排序方法则行不通。必须自定义排序。

 

页面设置：

<asp:GridView ID="gvList" runat="server" Width="100%" AutoGenerateColumns="False" CellPadding="4" ForeColor="#333333" BorderStyle="Solid" BorderWidth="1px" AllowSorting="True" onsorting="gvList_Sorting"> <RowStyle HorizontalAlign="Center" BackColor="#E8F3FC" /> <Columns> <asp:BoundField DataField="UserName" HeaderText="会员" SortExpression="UserName" /> <asp:BoundField DataField="Cared" HeaderText="卡号" SortExpression="Cared" /> <asp:BoundField DataField="ConsumCount" HeaderText="消费次数" SortExpression="ConsumCount" /> <asp:BoundField DataField="Levelid" HeaderText="等级" SortExpression="Levelid" /> <asp:BoundField DataField="JoinTime" HeaderText="注册时间" SortExpression="JoinTime" /> </Columns> <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" /> <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" /> <HeaderStyle CssClass="style2" Font-Bold="True" /> <EditRowStyle BackColor="#2461BF" /> <AlternatingRowStyle BackColor="White" /> </asp:GridView> 

需要注意：添加AllowSorting="True"， onsorting="gvList_Sorting"。

 

后台代码：

//排序 protected void gvList_Sorting(object sender, GridViewSortEventArgs e) { string sortExpression = e.SortExpression; if (GridViewSortDirection == SortDirection.Ascending) { GridViewSortDirection = SortDirection.Descending; SortGridView(sortExpression, "DESC"); } else { GridViewSortDirection = SortDirection.Ascending; SortGridView(sortExpression, "ASC"); } } private void SortGridView(string sortExpression, string direction) { DataSet ds = (DataSet)ViewState["vs"];//gridview的数据集，可以在绑定数据之后添加。如：this.gvList.DataSource = GetData(strWhere); this.gvList.DataBind(); ViewState["vs"] = gvList.DataSource; DataTable dt = ds.Tables[0]; DataView dv = new DataView(dt); dv.Sort = sortExpression + " " + direction; gvList.DataSource = dv; gvList.DataBind(); } public SortDirection GridViewSortDirection { get { if (ViewState["sortDirection"] == null) ViewState["sortDirection"] = SortDirection.Ascending; return (SortDirection)ViewState["sortDirection"]; } set { ViewState["sortDirection"] = value; } } 

参考了：http://blog.csdn.net/zhensoft163/archive/2010/06/07/5654256.aspx