惠州网站制作询问薇,北京网站建设最便宜的公司,公司网站的建设,颍上网站建设如何用Repeater进行分页 #xff0c;只要改一下连接数据库名和查询表就直接可用#xff0c;话不多说#xff0c;直接上代码。 前台代码#xff1a;
div classpageBar styleborder: 1px solid blue;asp:Literal IDltlPageBar只要改一下连接数据库名和查询表就直接可用话不多说直接上代码。 前台代码
div classpageBar styleborder: 1px solid blue;asp:Literal IDltlPageBar runatserver/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 emsp;emsp;emsp;a href\javascript:void(0)\b stylefont-size25px首页/b/aemsp;emsp;emsp;;}else{pageBar emsp;emsp;emsp;a href\ Request.CurrentExecutionFilePath ?Page1\b stylefont-size25px首页/b/aemsp;emsp;emsp;;}if ((currentPageIndex - 1) 1){pageBar emsp;emsp;emsp;a href\javascript:void(0)\b stylefont-size25px上一页/b/aemsp;emsp;emsp;;}else{pageBar emsp;emsp;emsp;a href\ Request.CurrentExecutionFilePath ?Page (currentPageIndex - 1) \b stylefont-size25px上一页/b/aemsp;emsp;emsp;;}if ((currentPageIndex 1) pds.PageCount){pageBar emsp;emsp;emsp;a href\javascript:void(0)\b stylefont-size25px下一页/b/aemsp;emsp;emsp;;}else{pageBar emsp;emsp;emsp;a href\ Request.CurrentExecutionFilePath ?Page (currentPageIndex 1) \b stylefont-size25px下一页/b/aemsp;emsp;emsp;;}if (currentPageIndex pds.PageCount){pageBar emsp;emsp;emsp;a href\javascript:void(0)\b stylefont-size25px末页/b/aemsp;emsp;emsp;;}else{pageBar emsp;emsp;emsp;a href\ Request.CurrentExecutionFilePath ?Page pds.PageCount \b stylefont-size25px末页/b/a;}return pageBar;}DataTable GetDocumentTable(string sql){//数据库连接字符串string strconn server.;uidsa;pwd123456;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 - 博客园
