http://dotnet.aspx.cc/ShowDetail.aspx?id=D5C6E29D-99F5-44E8-4FED-75AF892A53CB（转）
Repeater和DataList控件提供了一个快速、灵活的表现数据的方式，但是，它们没有内建的分页功能；DataGrid控件提供了内建的分页功能，但它的结构比较复杂。下面就用PagedDataSource类实现Repeater和DataList的分页。 PagedDataSource封装了DataGrid的分页属性，我们可以象DataGrid那样进行分页。代码如下：
C#版本
<%@ Page Language="C#" %><br /><%@ import namespace="System.Data" %><br /><%@ import namespace="System.Data.OleDb" %><br /><script language="C#" runat="server"><br />public void Page_Load(Object src,EventArgs e) {<br /> OleDbConnection objConn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + <br /> Server.MapPath("../aspxWeb.mdb"));<br /> OleDbDataAdapter objCommand=new OleDbDataAdapter("select * from Document",objConn);<br /> DataSet ds=new DataSet();<br /> objCommand.Fill(ds);<br /><br /> PagedDataSource objPds = new PagedDataSource();<br /> objPds.DataSource = ds.Tables[0].DefaultView;<br /> objPds.AllowPaging = true;<br /> objPds.PageSize = 5;<br /> int CurPage;<br /> if (Request.QueryString["Page"] != null)<br /> CurPage=Convert.ToInt32(Request.QueryString["Page"]);<br /> else<br /> CurPage=1;<br /><br /> objPds.CurrentPageIndex = CurPage-1;<br /> lblCurrentPage.Text = "当前页：" + CurPage.ToString();<br /><br /> if (!objPds.IsFirstPage)<br /> lnkPrev.NavigateUrl=Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage-1);<br /><br /> if (!objPds.IsLastPage)<br /> lnkNext.NavigateUrl=Request.CurrentExecutionFilePath+ "?Page=" + Convert.ToString(CurPage+1);<br /><br /> Repeater1.DataSource=objPds;<br /> Repeater1.DataBind();<br />}<br /></script><br /><html><br /><head><br /><title>Repeater控件分页的例子</title><br /><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><br /><style><br /> P,TD,DIV,SPAN {font-size:9pt}<br /></style><br /></head><br /><body><br /><form name="form1" method="POST" runat="server"><br /><div style="padding:5px;background-color:#dedede"><br /><asp:label ID="lblCurrentPage" runat="server"></asp:label></td><br /> <td> <asp:HyperLink id="lnkPrev" runat="server">上一页</asp:HyperLink><br /> <asp:HyperLink id="lnkNext" runat="server">下一页</asp:HyperLink> <br /></div><br /><hr size="1" color="#000099"/><br /><asp:Repeater ID="Repeater1" runat="server"><br /><Itemtemplate><br /><div style="padding:5px;background-color:#dedede"><br /><%# DataBinder.Eval(Container.DataItem, "Title") %><br /></div><br /></Itemtemplate><br /></asp:Repeater><br /></form><br /></body><br /></html><br />
VB.NET版本
<%@ Page Language="VB" %><br /><%@ import namespace="System.Data" %><br /><%@ import namespace="System.Data.OleDb" %><br /><script language="VB" runat="server"><br />Public Sub Page_Load(ByVal src As Object, ByVal e As EventArgs) <br /> Dim objConn As OleDbConnection = New OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("../aspxWeb.mdb")) <br /> Dim objCommand As OleDbDataAdapter = New OleDbDataAdapter ("select * from Document", objConn) <br /> Dim ds As DataSet = New DataSet () <br /> objCommand.Fill(ds) <br /> Dim objPds As PagedDataSource = New PagedDataSource () <br /> objPds.DataSource = ds.Tables(0).DefaultView <br /> objPds.AllowPaging = True <br /> objPds.PageSize = 5 <br /> Dim CurPage As Integer <br /> If Not (Request.QueryString("Page") Is Nothing) Then <br /> CurPage = Convert.ToInt32(Request.QueryString("Page")) <br /> Else <br /> CurPage = 1 <br /> End If <br /> objPds.CurrentPageIndex = CurPage - 1 <br /> lblCurrentPage.Text = "当前页：" + CurPage.ToString() <br /> If Not objPds.IsFirstPage Then <br /> lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1) <br /> End If <br /> If Not objPds.IsLastPage Then <br /> lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1) <br /> End If <br /> Repeater1.DataSource = objPds <br /> Repeater1.DataBind() <br />End Sub<br /></script><br /><html><br /><head><br /><title>Repeater控件分页的例子</title><br /><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><br /><style><br /> P,TD,DIV,SPAN {font-size:9pt}<br /></style><br /></head><br /><body><br /><form name="form1" method="POST" runat="server"><br /><div style="padding:5px;background-color:#dedede"><br /><asp:label ID="lblCurrentPage" runat="server"></asp:label></td><br /> <td> <asp:HyperLink id="lnkPrev" runat="server">上一页</asp:HyperLink><br /> <asp:HyperLink id="lnkNext" runat="server">下一页</asp:HyperLink> <br /></div><br /><hr size="1" color="#000099"/><br /><asp:Repeater ID="Repeater1" runat="server"><br /><Itemtemplate><br /><div style="padding:5px;background-color:#dedede"><br /><%# DataBinder.Eval(Container.DataItem, "Title") %><br /></div><br /></Itemtemplate><br /></asp:Repeater><br /></form><br /></body><br /></html><br />
|
扫一扫
167
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
