GridView按标头排序

最新推荐文章于 2021-04-19 14:31:31 发布

tanmarkjin

最新推荐文章于 2021-04-19 14:31:31 发布

阅读量338

点赞数

文章标签： sorting dataset string asp server xhtml

本文链接：https://blog.csdn.net/tanmarkjin/article/details/5739293

版权

<%@ 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();
}
}