使用PagedDataSource类实现Repeater分页显示功能

来源：互联网发布：美国人工智能机器人编辑：程序博客网时间：2024/05/17 10:26

<%@ import namespace="System.Data.OleDb" %>

public void Page_Load(Object src,EventArgs e)

{

OleDbConnection objConn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;

Data Source=" + Server.MapPath("../aspxWeb.mdb"));

OleDbDataAdapter objCommand=new OleDbDataAdapter("select * from Document",objConn);

DataSet ds=new DataSet();

objCommand.Fill(ds);

PagedDataSource objPds = new PagedDataSource();

objPds.DataSource = ds.Tables[0].DefaultView;

objPds.AllowPaging = true;

objPds.PageSize = 5;

int CurPage;

if (Request.QueryString["Page"] != null)

CurPage=Convert.ToInt32(Request.QueryString["Page"]);

else

CurPage=1;

objPds.CurrentPageIndex = CurPage-1;

lblCurrentPage.Text = "当前页：" + CurPage.ToString();

if (!objPds.IsFirstPage)

lnkPrev.NavigateUrl=Request.CurrentExecutionFilePath +"?Page=" + Convert.ToString(CurPage-1);

if (!objPds.IsLastPage)

lnkNext.NavigateUrl=Request.CurrentExecutionFilePath+ "?Page=" + Convert.ToString(CurPage+1);

Repeater1.DataSource=objPds;

Repeater1.DataBind();

}

</script>

<html>

<head>

<title>Repeater控件分页的例子</title>

<style>

P,TD,DIV,SPAN {font-size:9pt}

</style>

</head>

<body>

<asp:label ID="lblCurrentPage" runat="server"></asp:label></td>

<asp:HyperLink id="lnkNext" runat="server">下一页</asp:HyperLink>

</div>

<asp:Repeater ID="Repeater1" runat="server">

<%# DataBinder.Eval(Container.DataItem, "Title") %>

</div>

</Itemtemplate>

</asp:Repeater>

</form>

</body>

</html>