GridHeaderOrder.docVIP

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 Default3 : System.Web.UI.Page { //清清月儿的博客/21aspnet SqlConnection sqlcon; string strCon = Data Source=(local);Database=北风贸易;Uid=sa;Pwd=; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ViewState[SortOrder] = 身份证号码; ViewState[OrderDire] = ASC; bind(); } } protected void GridView1_Sorting(object sender, GridViewSortEventArgs e) { string sPage = e.SortExpression; if (ViewState[SortOrder].ToString() == sPage) { if (ViewState[OrderDire].ToString() == Desc) ViewState[OrderDire] = ASC; else ViewState[OrderDire] = Desc; } else { ViewState[SortOrder] = e.SortExpression; } bind(); } public void bind() { string sqlstr = select top 5 * from 飞狐工作室; sqlcon = new SqlConnection(strCon); SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon); DataSet myds = new DataSet(); sqlcon.Open(); myda.Fill(myds, 飞狐工作室); DataView view = myds.Tables[飞狐工作室].DefaultView; string sort = (string)ViewState[SortOrder] + + (string)ViewState[OrderDire]; view.Sort = sort; GridView1.DataSource = view; GridView1.DataBind(); sqlcon.Close(); } } 前台代码 HTML code asp:GridView ID=GridView1 runat=server AllowSorting=True AutoGenerateColumns=False CellPadding=3 Font-Size=9pt OnSorting=GridView1_Sorting BackColor=White BorderColor=#CCCCCC BorderStyle=None BorderWidth=1px FooterStyle BackColor=Wh