用PagedDataSource作为Repeater数据源的例子
后台:
<div align="center">
<asp:HyperLink ID="HyperLink3" runat="server">首页</asp:HyperLink>
<asp:HyperLink ID="HyperLink1" runat="server">上一页</asp:HyperLink> <a href=" http://courseware.lzu.edu.cn/shownews.asp?page=2"
target="_self"><asp:HyperLink ID="HyperLink2" runat="server">下一页</asp:HyperLink></a>
<a href=" http://courseware.lzu.edu.cn/shownews.asp?page=2" target="_self">
<asp:HyperLink ID="HyperLink4" runat="server">尾页</asp:HyperLink></a> 页次:<asp:Label
ID="Label1" runat="server" Text="Label"></asp:Label>/<asp:Label ID="Label2" runat="server"
Text="Label"></asp:Label>
共<asp:Label ID="Label3" runat="server" Text="Label"></asp:Label>条记录
</div>
//转自http://livder.blog.163.com/blog/static/1747576482010102354828245/
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection conn = db.GetCon();
string sql = "select * from tongz";
SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
sda.Fill(ds);
PagedDataSource pds = new PagedDataSource();
pds.DataSource = ds.Tables[0].DefaultView;
pds.AllowPaging = true;
pds.PageSize = 15;
int CurPage;
if (Request.QueryString["Page"] != null)
CurPage = Convert.ToInt32(Request.QueryString["Page"]);
else
CurPage = 1;
pds.CurrentPageIndex = CurPage - 1;
Label1.Text = CurPage.ToString();
Label2.Text = pds.PageCount.ToString();
Label3.Text = pds.DataSourceCount.ToString();
HyperLink3.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1";
HyperLink4.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(pds.PageCount);
if (!pds.IsFirstPage)
HyperLink1.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1);//上一页
if (!pds.IsLastPage)
HyperLink2.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1);//下一页
Repeater1.DataSource = pds;
Repeater1.DataBind();
}
前台:
<asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
<tr>
<td bordercolor="#C0C0C0" height="18">
<li class=li1>[2007-4-25] <a href="Tarticle.aspx?ID=<%#Eval("ID") %>"><%#Eval("Title") %></a></td>
</tr>
</ItemTemplate>
</asp:Repeater>
分页代码:
<div align="center">
<asp:HyperLink ID="HyperLink3" runat="server">首页</asp:HyperLink>
<asp:HyperLink ID="HyperLink1" runat="server">上一页</asp:HyperLink> <a href=" http://courseware.lzu.edu.cn/shownews.asp?page=2"
target="_self"><asp:HyperLink ID="HyperLink2" runat="server">下一页</asp:HyperLink></a>
<a href=" http://courseware.lzu.edu.cn/shownews.asp?page=2" target="_self">
<asp:HyperLink ID="HyperLink4" runat="server">尾页</asp:HyperLink></a> 页次:<asp:Label
ID="Label1" runat="server" Text="Label"></asp:Label>/<asp:Label ID="Label2" runat="server"
Text="Label"></asp:Label>
共<asp:Label ID="Label3" runat="server" Text="Label"></asp:Label>条记录
</div>