本文介绍两种在ASP.NET中使用GridView控件实现分页的方法。一种是在GridView控件的属性中启用分页并设置每页显示记录数，通过PageIndexChanging事件处理分页逻辑；另一种是利用LinkButton和Page_Load事件进行手动分页控制。
方法一:
新建一个页面然后在页面拖一个GridView控件在属性框中设置GridView控件的AllowPaing属性为True 然后再设置GridView的PageSize属性,源文件如下:
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames ="classId" CellPadding="5" OnRowDeleting="GridView1_RowDeleting" AllowPaging="True" OnPageIndexChanging="GridView1_PageIndexChanging" PageSize ="15">
<Columns>
<asp:BoundField DataField ="className" HeaderText ="名称" />
<asp:BoundField DataField="classDes" HeaderText="描述" SortExpression="classDes" />
</Columns>
<PagerTemplate>
<table style="font-size :12px;">
<tr>
<td> 总共<asp:Label ID="Label1" runat="server" Text="<%#((GridView)Container.NamingContainer).PageCount %>"></asp:Label>页 </td>
<td> 第<asp:Label ID="Label2" runat="server" Text="<%#((GridView)Container.NamingContainer).PageIndex+1 %>"></asp:Label>页 </td>
<td> <asp:LinkButton ID="LinkButton1" runat="server" CommandArgument ="1" CommandName ="Page" Enabled ="<%#((GridView)Container.NamingContainer).PageIndex!=0 %>">首页</asp:LinkButton> </td>
<td>
<asp:LinkButton ID="LinkButton2" runat="server" CommandArgument ="Prev" CommandName ="Page" Enabled ="<%#((GridView)Container.NamingContainer).PageIndex!=0 %>">上一页</asp:LinkButton> </td>
<td>
<asp:LinkButton ID="LinkButton3" runat="server" CommandArgument ="Next" CommandName ="Page" Enabled ="<%#((GridView)Container.NamingContainer).PageIndex!=((GridView)Container.NamingContainer).PageCount-1 %>">下一页 </asp:LinkButton> </td>
<td>
<asp:LinkButton ID="LinkButton4" runat="server" CommandArgument ="Last" CommandName ="Page" Enabled ="<%#((GridView)Container.NamingContainer).PageIndex!=((GridView)Container.NamingContainer).PageCount-1 %>">尾页</asp:LinkButton> </td>
<td>
<asp:LinkButton ID="LinkButton5" runat="server" CommandArgument ="-1" CommandName ="Page" ValidationGroup="1" >GO</asp:LinkButton> </td>
<td>
<asp:TextBox ID="txtNum" runat="server" Width="30px" Text ="<%#((GridView)Container.NamingContainer).PageIndex+1 %>" ValidationGroup="1"></asp:TextBox>
<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ErrorMessage="" ValidationExpression ="^/d+$" ControlToValidate ="txtNum" ValidationGroup="1"></asp:RegularExpressionValidator>
</td>
</tr>
</table>
</PagerTemplate>
</asp:GridView>
cs代码为:
/// <summary>
///为GridView控件绑定数据源
/// </summary>
private void bindClass()
{
string sql = "SELECT * FROM Class ORDER BY classId DESC";
DataExecute data = new DataExecute();
DataSet ds = data.returnDataSet(sql, CommandType.Text);
if (ds.Tables[0].Rows.Count != 0)
{
this.GridView1.DataSource = ds;
this.GridView1.DataBind();
//this.Count = ds.Tables[0].Rows.Count;
}
}
在GridView控件的PageIndexChanging事件中写相应的代码即可代码如下:
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView gv = (GridView)sender;
int newPageIndex = 0;
if (-2 == e.NewPageIndex)
{
TextBox tb = null;
GridViewRow gvr = gv.BottomPagerRow;
if (gvr != null)
{
tb = (TextBox)gvr.FindControl("txtNum");
}
if (tb != null)
{
newPageIndex = int.Parse(tb.Text) - 1;
}
}
else
{
newPageIndex = e.NewPageIndex;
}
newPageIndex = newPageIndex <= 0 ? 0 : newPageIndex;
this.GridView1.PageIndex = newPageIndex;
//分页后重新绑定数据源
this.bindClass();
}
注：
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if ((string)e.CommandName == "Page")
{
//GridView theGrid = (GridView)sender;
//int newPageIndex = 0;
//GridViewRow pagerRow = theGrid.BottomPagerRow;
//TextBox txtNewPageIndex = (TextBox)pagerRow.FindControl("txtNewPageIndex");
//if (null != txtNewPageIndex && txtNewPageIndex.Text != "")
//{
// newPageIndex = int.Parse(txtNewPageIndex.Text) - 1;//Get the NewPageIndex
//}
//else
//{
// newPageIndex = 0;
//}
//string pageArgument = (string)e.CommandArgument;
//switch (pageArgument)
//{
// case "first":
// gvProList.PageIndex = 0;
// break;
// case "Prev":
// if (gvProList.PageIndex > 0)
// {
// gvProList.PageIndex--;
// }
// break;
// case "Next":
// gvProList.PageIndex++;
// break;
// case "last":
// gvProList.PageIndex = gvProList.PageCount;
// break;
// case "-1":
// gvProList.PageIndex = newPageIndex;
// break;
//}
//BandBindGV();//更新分页数据，否则要点两次才有反应。
}
（如果RowCommand 报错，也可以到RowCommand 写）
方法二:
protected void Page_Load(object sender, EventArgs e)
{
btnFirst.Text = "最首页";
btnPrev.Text = "前一页";
btnNext.Text = "下一页";
btnLast.Text = "最后页";
GridView1.DataBind();
ShowPageChangedStatus();
}
private void ShowPageChangedStatus()
{
lblCurrentIndex.Text = "第" + (GridView1.PageIndex + 1).ToString() + "页";
lblPageCount.Text = "总共 " + GridView1.PageCount.ToString() + " 页";
}
public void PagerButtonClick(object sender, EventArgs e)
{
string arg = ((LinkButton)sender).CommandArgument.ToString();
switch (arg)
{
case "next":
if (GridView1.PageIndex < (GridView1.PageCount - 1))
{
GridView1.PageIndex += 1;
}
break;
case "prev":
if (GridView1.PageIndex > 0)
{
GridView1.PageIndex -= 1;
}
break;
case "last":
GridView1.PageIndex = (GridView1.PageCount - 1);
break;
default:
GridView1.PageIndex = System.Convert.ToInt32(arg);
break;
}
GridView1.DataBind();
ShowPageChangedStatus();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
int startIndex;
startIndex = GridView1.PageIndex * GridView1.PageSize;
GridView1.PageIndex = e.NewPageIndex;
GridView1.DataBind();
ShowPageChangedStatus();
}
<asp:label id="lblPageCount" runat="server"></asp:label>
<asp:label id="lblCurrentIndex" runat="server"></asp:label>
<asp:linkbutton id="btnFirst" onclick="PagerButtonClick" runat="server"
Font-size="8pt" ForeColor="navy" CommandArgument="0"></asp:linkbutton>
<asp:linkbutton id="btnPrev" onclick="PagerButtonClick" runat="server"
Font-size="8pt" ForeColor="navy" CommandArgument="prev"></asp:linkbutton>
<asp:linkbutton id="btnNext" onclick="PagerButtonClick" runat="server"
Font-size="8pt" ForeColor="navy" CommandArgument="next"></asp:linkbutton>
<asp:linkbutton id="btnLast" onclick="PagerButtonClick" runat="server"
Font-size="8pt" ForeColor="navy" CommandArgument="last"></asp:linkbutton>
扫一扫
4491
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
