使用用户控件AspNetPager+Gridview实现分页功能
1 前台代码：
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="TestPager.aspx.cs" Inherits="TestPager" %>
<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>
<!DOCTYPE html>
<html >
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div >
<asp:GridView ID="GridView1" runat="server" HorizontalAlign="Center">
<RowStyle HorizontalAlign="Center" />
</asp:GridView>
<br/><br/><br/>
<webdiyer:AspNetPager ID="AspNetPager1" runat="server" CustomInfoHTML="共%PageCount%页，
当前为第%CurrentPageIndex%页，每页%PageSize%条"
FirstPageText="首页" LastPageText="尾页" NextPageText="下一页" PrevPageText="上一页"
ShowBoxThreshold="1" ShowCustomInfoSection="right" Width="100%"
OnPageChanging="AspNetPager1_PageChanging" PageSize="1" ButtonImageAlign="Middle"
CustomInfoTextAlign="Center" Direction="LeftToRight" HorizontalAlign="Center" NumericButtonCount="5"
CenterCurrentPageButton="True">
</webdiyer:AspNetPager>
</div>
</form>
</body>
</html>
2后台代码：
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
public partial class TestPager : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GridBindData();
}
}
private void GridBindData()
{
string strConn = ConfigurationManager.ConnectionStrings["conStr"].ConnectionString;
using (SqlConnection con = new SqlConnection(strConn))
{
con.Open();
string sql = "select t.* from Student t";
using (SqlCommand cmd = new SqlCommand(sql, con))
{
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
DataSet ds = new DataSet();
da.Fill(ds, "Student");
PagedDataSource pds = new PagedDataSource();
pds.DataSource = ds.Tables[0].DefaultView;
pds.AllowPaging = true;
AspNetPager1.RecordCount = pds.Count;
pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
pds.PageSize = AspNetPager1.PageSize;
this.GridView1.DataSource = pds;
this.GridView1.DataBind();
}
}
}
}
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
AspNetPager1.CurrentPageIndex = e.NewPageIndex;
GridBindData();
}
}
3 测试截图：
