OleDbConnection objConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("~/App_Data/db1.mdb")); OleDbDataAdapter objCommand = new OleDbDataAdapter("select * from T_post", 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();
<div> <asp:Label ID="lblCurrentPage" runat="server" /> <asp:HyperLink ID="lnkPrev" runat="server">上一页</asp:HyperLink> <asp:HyperLink ID="lnkNext" runat="server">下一页</asp:HyperLink> </div>