如何在GridView中实现双向排序

 

using  System;
using  System.Data;
using  System.Configuration;
using  System.Collections;
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.SqlClient;

public   partial   class  GridViewCheckBox : System.Web.UI.Page
... {
    protected void Page_Load(object sender, EventArgs e)
    ...{
        if (!IsPostBack)
        ...{
            ViewState["SortOrder"] = "firstname";
            ViewState["OrderDire"] = "asc";
            GridViewDataBind();
        }
            
    }

    private void GridViewDataBind()
    ...{
        string connStr = ConfigurationManager.ConnectionStrings["northwind"].ConnectionString;
        SqlConnection conn = new SqlConnection(connStr);
        SqlDataAdapter da = new SqlDataAdapter("select firstname, lastname, city, birthdate from employees", conn);
        conn.Open();
        DataSet ds = new DataSet();
        try
        ...{
            da.Fill(ds, "testTable");
            DataView view = ds.Tables["testTable"].DefaultView;
            string sort = (string)ViewState["SortOrder"] + " " + (string)ViewState["OrderDire"];
            view.Sort = sort;
            //dgCheckBox.DataSource = ds.Tables["testTable"].DefaultView;
            dgCheckBox.DataSource = view;
            dgCheckBox.DataBind();
        }
        catch (Exception error)
        ...{
            Response.Write(error.ToString());
        }
        finally 
        ...{
            conn.Close();
        }
    }
    protected void cmdSelectAll_Click(object sender, EventArgs e)
    ...{
        System.Web.UI.WebControls.CheckBox chkEport;
        if (cmdSelectAll.Text == "全选")
        ...{
            foreach (GridViewRow gridviewrow in dgCheckBox.Rows)
            ...{
                chkEport = (CheckBox)gridviewrow.FindControl("chkEport");
                chkEport.Checked = true;
            }
            cmdSelectAll.Text = "取消";
        }
        else
        ...{
            foreach (GridViewRow gridviewrow in dgCheckBox.Rows)
            ...{
                chkEport = (CheckBox)gridviewrow.FindControl("chkEport");
                chkEport.Checked = false;
            }
            cmdSelectAll.Text = "全选";
        }
    }
    protected void cmdFindSelected_Click(object sender, EventArgs e)
    ...{
        System.Web.UI.WebControls.CheckBox chkEport;
        string strID;
        System.Text.StringBuilder strMsg = new System.Text.StringBuilder("选中项的City字段值分别为：<hr color=red>");
        foreach (GridViewRow gridviewrow in dgCheckBox.Rows)
        ...{
            chkEport = (CheckBox)gridviewrow.FindControl("chkEport");
            if (chkEport.Checked)
            ...{
                strID = ((Label)(gridviewrow.FindControl("lblCity"))).Text;
                strMsg.Append(strID + "<br><hr color=red>");
            }
            message.Text = strMsg.ToString();
        }
    }

    protected void dgCheckBox_Sorting(object sender, GridViewSortEventArgs e)
    ...{
        string vortExp = e.SortExpression;
        if (ViewState["SortOrder"].ToString() == vortExp)
        ...{
            if ((string)ViewState["OrderDire"] == "desc")
            ...{
                ViewState["OrderDire"] = "asc";
            }
            else
            ...{
                ViewState["OrderDire"] = "asc";
            }
        }
        else
        ...{
            ViewState["SortOrder"] = e.SortExpression;
        }
        GridViewDataBind();
    }
    protected void dgCheckBox_PageIndexChanging(object sender, GridViewPageEventArgs e)
    ...{
        dgCheckBox.PageIndex = e.NewPageIndex;
        GridViewDataBind();
    }
}

GridViewCheckBox.aspx代码如下:

     < form id = " form1 "  runat = " server " >
     < div >
         < table style = " width: 566px " >
             < tr >
                 < td style = " width: 112px "   >
                     < asp:GridView ID = " dgCheckBox "  runat = " server "  GridLines = " vertical "  AutoGenerateColumns = " false "  PagerSettings - Mode = " numeric "  Width = " 446px "
                     AllowSorting = " true "  AllowPaging = " true "  PageSize = " 5 "    OnSorting = " dgCheckBox_Sorting "  OnPageIndexChanging = " dgCheckBox_PageIndexChanging " >
                     < SelectedRowStyle Font - Bold = " True "  ForeColor = " White "  BackColor = " #008A8C " />
                     < AlternatingRowStyle BackColor = " AppWorkspace " />
                     < RowStyle ForeColor = " ActiveBorder "  BackColor = " ActiveCaption "   />
                     < HeaderStyle Font - Bold = " True "  ForeColor = " ActiveCaptionText "  BackColor = " AliceBlue "   />
                     < FooterStyle ForeColor = " AppWorkspace "  BackColor = " Aqua "   />
                     < Columns >
                     < asp:TemplateField >
                     < ItemTemplate >
                     < asp:CheckBox ID = " chkEport "  runat = " server "   />
                     </ ItemTemplate >
                     < EditItemTemplate >
                     < asp:CheckBox ID = " chkEportON "  runat = " server "   />
                     </ EditItemTemplate >
                     </ asp:TemplateField >
                     < asp:BoundField DataField = " lastname "  HeaderText = " lastname "  SortExpression = " lastname " />
                     < asp:BoundField DataField = " firstname "  HeaderText = " firstname "  SortExpression = " firstname " />
                     < asp:BoundField DataField = " BirthDate "  HeaderText = " BirthDate "  SortExpression = " BirthDate "  DataFormatString = " {0:D} "   />
                     < asp:TemplateField >
                     < ItemTemplate >
                     < asp:Label ID = " lblCity "  runat = " server "  Text = ' <%#Eval("city") %> ' ></ asp:Label >
                     </ ItemTemplate >
                     </ asp:TemplateField >
                    
                     </ Columns >
                     < PagerStyle HorizontalAlign = " Right "  ForeColor = " Aquamarine "  BackColor = " Azure " />
                     </ asp:GridView >
                 </ td >
             </ tr >
             < tr >
             < td style = " width: 112px " >
             < asp:Button ID = " cmdSelectAll "  runat = " server "  Text = " 全选 "  OnClick = " cmdSelectAll_Click "   />& nbsp; < asp:Button ID = " cmdFindSelected "  runat = " server "  Text = " 取得选择的项 "  OnClick = " cmdFindSelected_Click "   />
             </ td >
             </ tr >< tr >
             < td >< asp:Label ID = " message "  runat = " server " ></ asp:Label ></ td >
             </ tr >
         </ table >
    
     </ div >
     </ form >

 GridViewCheckBox.aspx.cs代码如下: