GridView实现正反向双向排序(转帖)

后台代码：

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

public partial class _Default : System.Web.UI.Page 
{
    public void Bind()
    {
        OleDbConnection conn = new OleDbConnection();
        conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("abc.mdb");
        string sql = "select * from grade";
        conn.Open();
        OleDbDataAdapter da = new OleDbDataAdapter(sql, conn);
        DataSet ds = new DataSet();
        da.Fill(ds, "grade");
        DataView view = ds.Tables["grade"].DefaultView;
        string sort=(string)ViewState["排序字段"]+" "+(string)ViewState["排序方式"];
        view.Sort = sort;
        GridView1.DataSource = view;
        GridView1.DataBind();
        conn.Close(); 

    }

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            ViewState["排序字段"] = "语文";
            ViewState["排序方式"] = "DESC";
            Bind();
        }
    }
    protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
    {
        string spage = e.SortExpression;
        if (ViewState["排序字段"].ToString() == spage)
        {
            if (ViewState["排序方式"].ToString() == "DESC")
                ViewState["排序方式"] = "ASC";
            else
                ViewState["排序方式"] = "DESC";
        }
        else
            ViewState["排序字段"] = e.SortExpression;
        Bind();
    }
}

前台代码：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False"
            OnSorting="GridView1_Sorting">
            <Columns>
                <asp:BoundField DataField="学号" HeaderText="学号" ReadOnly="True" SortExpression="学号" />
                <asp:BoundField DataField="姓名" HeaderText="姓名" SortExpression="姓名" />
                <asp:BoundField DataField="性别" HeaderText="性别" SortExpression="性别" />
                <asp:BoundField DataField="语文" HeaderText="语文" SortExpression="语文" />
                <asp:BoundField DataField="数学" HeaderText="数学" SortExpression="数学" />
                <asp:BoundField DataField="英语" HeaderText="英语" SortExpression="英语" />
                <asp:BoundField DataField="综合" HeaderText="综合" SortExpression="综合" />
            </Columns>
        </asp:GridView>
    
    </div>
    </form>
</body>
</html>

原文地址：http://hi.baidu.com/lsm%B5%D8%C5%CC/blog/item/51df8c08d34235226b60fb8e.html