<%@ 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> GridView实现正反双项排序功能 </title> </head> <body> <form id= "form1 " runat= "server "> <div> <table align= "center " border= "1 " cellpadding= "0 " cellspacing= "0 "> <tr> <td style= "font-size: 9pt; color: #ff0000; text-align: center "> 用户信息 </td> </tr> <tr> <td style= "text-align: center "> <asp:GridView ID= "GridView1 " runat= "server " AllowSorting= "True " AutoGenerateColumns= "False " CellPadding= "4 " Font-Size= "9pt " ForeColor= "#333333 " GridLines= "None " OnSorting= "GridView1_Sorting " ShowHeader= "True "> <FooterStyle BackColor= "#990000 " Font-Bold= "True " ForeColor= "White " /> <Columns> <asp:BoundField DataField= "id " HeaderText= "用户ID " SortExpression= "id "> <ControlStyle Font-Underline= "False " /> </asp:BoundField> <asp:BoundField DataField= "name " HeaderText= "用户姓名 " SortExpression= "name "> <ControlStyle Font-Underline= "False " /> </asp:BoundField> <asp:BoundField DataField= "sex " HeaderText= "性别 " SortExpression= "sex "> <ControlStyle Font-Underline= "False " /> </asp:BoundField> <asp:BoundField DataField= "nPlace " HeaderText= "籍贯 " SortExpression= "nPlace "> <ControlStyle Font-Underline= "False " /> </asp:BoundField> </Columns> <RowStyle BackColor= "#FFFBD6 " ForeColor= "#333333 " /> <SelectedRowStyle BackColor= "#FFCC66 " Font-Bold= "True " ForeColor= "Navy " /> <PagerStyle BackColor= "#FFCC66 " ForeColor= "#333333 " HorizontalAlign= "Center " /> <HeaderStyle BackColor= "#990000 " Font-Bold= "True " ForeColor= "White " /> <AlternatingRowStyle BackColor= "White " /> </asp:GridView> </td> </tr> </table> </div> </form> </body> </html> 后台代码如下: 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.SqlClient; public partial class _Default : System.Web.UI.Page { SqlConnection sqlcon; string strCon = "Data Source=(local);Database=lcTest;Uid=sa;Pwd=sa "; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ViewState[ "SortOrder "] = "id "; 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 * from tb_Member "; sqlcon = new SqlConnection(strCon); SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon); DataSet myds = new DataSet(); sqlcon.Open(); myda.Fill(myds, "tb_Member "); DataView view = myds.Tables[ "tb_Member "].DefaultView; string sort = (string)ViewState[ "SortOrder "] + " " + (string)ViewState[ "OrderDire "]; view.Sort = sort; GridView1.DataSource = view; GridView1.DataBind(); sqlcon.Close(); } } |
GridView按标头排序
最新推荐文章于 2022-04-08 10:37:48 发布