ASP.NET Repeater 分页

最新推荐文章于 2023-12-13 09:47:15 发布

Index_Demo

最新推荐文章于 2023-12-13 09:47:15 发布

阅读量240

点赞数

分类专栏： ASP.NET Web 文章标签： asp.net ui 后端

原文链接：https://www.cnblogs.com/ranran/p/4140511.html

版权

ASP.NET Web 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

如何用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 += "&emsp;&emsp;&emsp;<a href=\"javascript:void(0)\"><b style='font-size='25px''>首页</b></a>&emsp;&emsp;&emsp;";
            }
            else
            {
                pageBar += "&emsp;&emsp;&emsp;<a href=\"" + Request.CurrentExecutionFilePath + "?Page=1\"><b style='font-size='25px''>首页</b></a>&emsp;&emsp;&emsp;";
            }
            if ((currentPageIndex - 1) < 1)
            {
                pageBar += "&emsp;&emsp;&emsp;<a href=\"javascript:void(0)\"><b style='font-size='25px''>上一页</b></a>&emsp;&emsp;&emsp;";
            }
            else
            {
                pageBar += "&emsp;&emsp;&emsp;<a href=\"" + Request.CurrentExecutionFilePath + "?Page=" + (currentPageIndex - 1) + "\"><b style='font-size='25px''>上一页</b></a>&emsp;&emsp;&emsp;";
            }
            if ((currentPageIndex + 1) > pds.PageCount)
            {
                pageBar += "&emsp;&emsp;&emsp;<a href=\"javascript:void(0)\"><b style='font-size='25px''>下一页</b></a>&emsp;&emsp;&emsp;";
            }
            else
            {
                pageBar += "&emsp;&emsp;&emsp;<a href=\"" + Request.CurrentExecutionFilePath + "?Page=" + (currentPageIndex + 1) + "\"><b style='font-size='25px''>下一页</b></a>&emsp;&emsp;&emsp;";
            }
            if (currentPageIndex == pds.PageCount)
            {
                pageBar += "&emsp;&emsp;&emsp;<a href=\"javascript:void(0)\"><b style='font-size='25px''>末页</b></a>&emsp;&emsp;&emsp;";
            }
            else
            {
                pageBar += "&emsp;&emsp;&emsp;<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=数据库名";
            //实例化连接对象，并赋值strconn
            SqlConnection 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();
            //返回DataTable
            return Temp_dt;
        }
    }
}

参考链接：Repeater控件的分页实现 - Ranran - 博客园