Default.aspx.cs
using System;
using System.Data;
using System.Configuration;
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;
using System.Data.OleDb;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Repeater1.DataSource = pds();//通过类PagedDataSource来实现分页,pds()方法返回一个类PagedDataSource的对象pds
Repeater1.DataBind();
}
}
private PagedDataSource pds()
{
string connectionString = "provider=microsoft.jet.oledb.4.0;data source=D:/WebSites/Repeater/App_Data/student.mdb";
OleDbConnection myConnetion = new OleDbConnection(connectionString);
OleDbDataAdapter oda = new OleDbDataAdapter("select * from message", myConnetion);
DataSet ds = new DataSet();
oda.Fill(ds, "message");
OleDbDataAdapter oda2 = new OleDbDataAdapter("select * from reply", myConnetion);
oda2.Fill(ds, "reply");
ds.Relations.Add("myrelation",ds.Tables["message"].Columns["id"],ds.Tables["reply"].Columns["id"]);//新增一个关系myrelation把表message和reply通过字段id连接起来
PagedDataSource pds=new PagedDataSource();
pds.DataSource=ds.Tables["message"].DefaultView;
pds.AllowPaging=true;//允许分页
pds.PageSize=2;//分页数
pds.CurrentPageIndex=Convert.ToInt32(Request.QueryString["page"]);//当前页CurrentPageIndex,通过获得传来的参数page来设置
return pds;
}