GridView按字段升降排序

前台：

 <asp:GridView ID="gvd_List" runat="server" OnSorting="gvd_List_Sorting" AllowSorting="True"
            AllowPaging="True" CaptionAlign="Top" GridLines="Horizontal" Height="13px"
            Width="228px" >
        </asp:GridView>

<%-- <asp:GridView ID="gvd_List" runat="server" OnSorting="gvd_List_Sorting" AllowSorting="True"
                AutoGenerateColumns="false" AllowPaging="True" CaptionAlign="Top" GridLines="Horizontal"
                Height="13px" Width="628px">
                <Columns>
                    <asp:BoundField DataField="Uid" HeaderText="Uid" SortExpression="Uid" />
                    <asp:BoundField DataField="U_Name" HeaderText="U_Name" SortExpression="U_Name" />
                    <asp:BoundField DataField="Sex" HeaderText="Sex" SortExpression="Sex" />
                    <asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
                    <asp:BoundField DataField="AddDate" HeaderText="AddDate" SortExpression="AddDate" />
                    <asp:BoundField DataField="Cid" HeaderText="Cid" SortExpression="Cid" />
                    <asp:BoundField DataField="Aid" HeaderText="Aid" SortExpression="Aid" />
                    <asp:BoundField DataField="Status" HeaderText="Status" SortExpression="Status" />
                </Columns>
            </asp:GridView>--%>

后台：

 

 protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
            this.backdatast();
            this.binddatatoGridView();
        }
    }

    private DataSet backdatast()
    {//自定义方法，返回一个dataset对象
        string strCon = ConfigurationManager.AppSettings["DataBaseConnection"];
        //定义连接数据库变量
        SqlConnection dsConn = new SqlConnection(strCon);
        //定义DataSet对象
        DataSet DS = new DataSet();
        //定义SqlDataAdapter对象
        SqlDataAdapter MyCommand = new SqlDataAdapter("select * from UserInfo ", dsConn);
        //填充数据
        MyCommand.Fill(DS, "UserInfo");
        return DS;
    }
    private void binddatatoGridView()
    {//自定义方法
        this.gvd_List.DataSource = this.backdatast().Tables[0].DefaultView;
        this.gvd_List.DataBind();
    }

    public SortDirection GridViewSortDirection
    {//属性设置
        get
        {
            if (ViewState["sortDirection"] == null)
            {
                ViewState["sortDirection"] = SortDirection.Ascending;
            }
            return (SortDirection)ViewState["sortDirection"];
        }
        set
        {
            ViewState["sortDirection"] = value;
        }
    }
    protected void gvd_List_Sorting(object sender, GridViewSortEventArgs e)
    {//GridView的sorting事件
        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 sortdirection)
    {//自定义一个函数，
        DataTable dt = this.backdatast().Tables[0];
        DataView dv = new DataView(dt);

        dv.Sort = sortExpression + " " + sortdirection;

        gvd_List.DataSource = dv;
        this.gvd_List.DataBind();
    }