gridview排序和分页
前台代码如下：
代码
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title></title>
<style type="text/css" >
body{width: 800px;height: 100px;margin: 0px auto;margin-bottom:20px;background-color:#F0FBEB;}
span{color :Maroon ;}
.div{margin-top:80px; text-align :center }
.table{ border-collapse :collapse ;width: 600px;height: 100px;margin: 0px auto;margin-bottom:20px;border:1px solid #BBE1F1;background-color: #EEFAFF}
.table th{ margin: 1px;background-color: #E2EAF8;height: 24px; width :14%; color :Maroon ; border-right : 1px solid #CCEFF5;border-bottom :1px solid #CCEFF5;}
.table td{ border-right : 1px solid #CCEFF5;border-bottom :1px solid #CCEFF5;}
</style>
</head>
<body>
<form id="form1" runat="server">
<div class="div ">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns ="False"
onrowcommand="GridView1_RowCommand" AllowPaging="True" AllowSorting="True"
onpageindexchanging="GridView1_PageIndexChanging"
PageSize="5" GridLines="None" >
<Columns >
<asp:TemplateField >
<HeaderTemplate >
<table class ="table " >
<tr>
<th>相片</th>
<th><asp:LinkButton ID="LinkButton3" CommandName ="number" runat="server" ><span>读者编号</span></asp:LinkButton></th>
<th><asp:LinkButton ID="LinkButton4" CommandName ="name" runat="server"><span>读者姓名</span></asp:LinkButton></th>
<th><asp:LinkButton ID="LinkButton5" CommandName ="xingb" runat="server"><span>性别</span></asp:LinkButton></th>
<th><asp:LinkButton ID="LinkButton6" CommandName ="tel" runat="server"><span>电话</span></asp:LinkButton></th>
<th><asp:LinkButton ID="LinkButton7" CommandName ="tushujynum" runat="server"><span>图书借阅次数</span></asp:LinkButton></th>
<th>操作</th>
</tr>
</HeaderTemplate>
<ItemTemplate >
<tr>
<td><img alt ="" src ='readImage.aspx?id=<%#Eval("number") %>' width ="40px" height ="40px" /><%-- 此处是显示数据库中的二进制图片 代码省略 --%> </td>
<td><%#Eval("number") %></td>
<td><%#Eval("name") %></td>
<td><%#Eval("xingb") %></td>
<td><%#Eval("tel") %></td>
<td><%#Eval("tushujynum") %></td>
<td>
<asp:LinkButton ID="LinkButton1" CommandName ="deletee" CommandArgument ='<%#Eval("number") %>' runat="server">删除</asp:LinkButton>
<asp:LinkButton ID="LinkButton2" CommandName ="updatee" CommandArgument ='<%#Eval("number") %>' runat="server">修改</asp:LinkButton>
</td>
</tr>
</ItemTemplate>
<FooterTemplate >
</table>
</FooterTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
</form>
</body>
</html>
页面后台代码如下：
代码
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
namespace WebPricatice
{
public partial class gridview : System.Web.UI.Page
{
BLL.Test1 bll = new BLL.Test1();//实例化业务逻辑层的Test1的方法
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GridView1.Attributes.Add("SortExpression", "number");
GridView1.Attributes.Add("SortDirection", "ASC");
BindGrid();
}
}
public void BindGrid()
{
// 获取GridView排序数据列及排序方向
string sortExpression = GridView1.Attributes["SortExpression"];
string sortDirection = GridView1.Attributes["SortDirection"];
DataTable dt=bll.getList().Tables[0];//bll.getlist()是得到DataSet数据集的一个方法----代码已省略
//dt包括的字段有"number,name,xingb,tel,tusjynum等";
dt.DefaultView .Sort =string.Format("{0} {1}", sortExpression, sortDirection);
//给gridview绑定数据
GridView1.DataSource = dt;
GridView1.DataBind();
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
switch (e.CommandName)
{
case "deletee":
//删除id为e.CommandArgument的项
//Response.Write("<script>alert(\"删除'" + e.CommandArgument + "'\")</script>");
break;
case "updatee":
//修改id为e.CommandArgument的项----代码省略
// Response.Write("alert(\"修改'" + e.CommandArgument + "'\")");
break;
case "number":
bindgridsort("number");
break;
case "name":
bindgridsort("name");
break;
case "xingb":
bindgridsort("xingb");
break;
case "tel":
bindgridsort("tel");
break;
case "tushujynum":
bindgridsort("tushujynum");
break;
default: break;
}
}
/// <summary>
/// 得到gridview排序的顺序
/// </summary>
/// <param name="fieldstr">你要排序的字段名称</param>
public void bindgridsort(string fieldstr)
{
// 错误的属性设置方法：SortExpression、SortDirection均是GridView只读属性，无法直接赋值。
//this.GridView1.SortExpression = "id";
//this.GridView1.SortDirection = "ASC";
string sortDirection = "ASC";
if (fieldstr == GridView1.Attributes["SortExpression"])
{
//获得下一次的排序状态
sortDirection = GridView1.Attributes["SortDirection"].ToString() == sortDirection ? "DESC" : "ASC";
}
GridView1.Attributes["SortExpression"] = fieldstr;
GridView1.Attributes["SortDirection"] = sortDirection;
BindGrid();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
BindGrid();
}
}
}
