网站初期推广百度知道合伙人答题兼职入口
如何用Repeater进行分页 ，只要改一下连接数据库名和查询表就直接可用，话不多说，直接上代码。
前台代码：
<div class="pageBar" style="border: 1px solid blue;"><asp:Literal ID="ltlPageBar" runat="server"></asp:Literal>
</div>/*放到自己想放到的位置*/后台代码：
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
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;namespace WebTest
{public partial class Index : System.Web.UI.Page{protected void Page_Load(object sender, EventArgs e){if (!Page.IsPostBack)//回传数据{int pageIndex = 1;try{pageIndex = Convert.ToInt32(Request.QueryString["Page"]);if (pageIndex <= 0) pageIndex = 1;}catch{pageIndex = 1;}//下面这行查询你想查询的数据库表string sql = string.Format("SELECT * FROM tb_user");DataTable dt = GetDocumentTable(sql);PagedDataSource pds = new PagedDataSource();pds.DataSource = dt.DefaultView; // 设置数据源pds.AllowPaging = true; // 设置指示是否启用分页的值pds.PageSize = 10; // 设置要在每页显示的数量pds.CurrentPageIndex = pageIndex - 1; //设置当前索引UserInfoRep.DataSource = pds;UserInfoRep.DataBind();ltlPageBar.Text = GetPageBar(pds);}}// 分页条private string GetPageBar(PagedDataSource pds){string pageBar = string.Empty;int currentPageIndex = pds.CurrentPageIndex + 1;if (currentPageIndex == 1){pageBar += "   <a href=\"javascript:void(0)\"><b style='font-size='25px''>首页</b></a>   ";}else{pageBar += "   <a href=\"" + Request.CurrentExecutionFilePath + "?Page=1\"><b style='font-size='25px''>首页</b></a>   ";}if ((currentPageIndex - 1) < 1){pageBar += "   <a href=\"javascript:void(0)\"><b style='font-size='25px''>上一页</b></a>   ";}else{pageBar += "   <a href=\"" + Request.CurrentExecutionFilePath + "?Page=" + (currentPageIndex - 1) + "\"><b style='font-size='25px''>上一页</b></a>   ";}if ((currentPageIndex + 1) > pds.PageCount){pageBar += "   <a href=\"javascript:void(0)\"><b style='font-size='25px''>下一页</b></a>   ";}else{pageBar += "   <a href=\"" + Request.CurrentExecutionFilePath + "?Page=" + (currentPageIndex + 1) + "\"><b style='font-size='25px''>下一页</b></a>   ";}if (currentPageIndex == pds.PageCount){pageBar += "   <a href=\"javascript:void(0)\"><b style='font-size='25px''>末页</b></a>   ";}else{pageBar += "   <a href=\"" + Request.CurrentExecutionFilePath + "?Page=" + pds.PageCount + "\"><b style='font-size='25px''>末页</b></a>";}return pageBar;}DataTable GetDocumentTable(string sql){//数据库连接字符串string strconn = "server=.;uid=sa;pwd=123456;database=数据库名";//实例化连接对象，并赋值strconnSqlConnection conn = new SqlConnection(strconn);//打开连接对象conn.Open();//临时存储DataTable Temp_dt = new DataTable();//实例化数据库适配器SqlDataAdapter Dad = new SqlDataAdapter(sql, conn);//填充Dad.Fill(Temp_dt);//关闭连接对象conn.Close();//释放连接对象资源conn.Dispose();//返回DataTablereturn Temp_dt;}}
}参考链接：Repeater控件的分页实现 - Ranran - 博客园