GridView自动排序

设置GridView的属性 AllowSorting为True。并触发OnSorting事件（找到GridView的Sorting事件，双击即可）。 GridView绑定字段时，给需要排序的列添加SortExpression,如要按ID列排序，则设置ID对应的列的SortExpression="ID",SortExpression的字段应该是数据表中对应的字段，如下例：

<asp:GridView ID="grdInfo" runat="server" AutoGenerateColumns="False" Width="100%" EmptyDataText="没有找到相关的信息" OnRowDataBound="grdInfo_RowDataBound" AllowSorting="True" OnSorting="grdInfo_Sorting" > <Columns> <asp:BoundField HeaderText="序号" /> <asp:TemplateField HeaderText="管理号" SortExpression="gzmnum"> <ItemTemplate> <asp:HyperLink ID="hyMnum" runat="server" Text='<%# Bind("gzmnum") %>' ></asp:HyperLink> </ItemTemplate> </asp:TemplateField> <asp:BoundField HeaderText="计划时间" DataField="计划时间" HtmlEncode="False" DataFormatString="{0:d}" SortExpression="plandate" /> </Columns> <HeaderStyle BackColor="#336699" ForeColor="White" Height="20px" /> <RowStyle Height="20px" /> <EmptyDataRowStyle BackColor="#C0C0FF" Height="20px" /> </asp:GridView>

后台：

protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.grdInfo.Attributes["SortDirection"] = "Asc"; GetGridViewBind(null);//绑定数据库数据到GridView } } protected void GetGridViewBind(string strOrder) { string strSelect = "select * from A "; if (strOrder != null) { strSelect += strOrder; } …… } protected void grdInfo_Sorting(object sender, GridViewSortEventArgs e) { string sortExpression = e.SortExpression; string strOrder = null; string sortDirection = "Asc"; if (sortDirection==grdInfo.Attributes["SortDirection"].ToString()) { sortDirection = "Desc"; strOrder = " order by " + sortExpression + " desc"; } else { sortDirection = "Asc"; strOrder = " order by " + sortExpression + " asc"; } this.grdInfo.Attributes["SortDirection"] = sortDirection; GetGridViewBind(strOrder); }