OleDbAdapter

 

using System;
using System.Data;
using System.Data.OleDb;

namespace Mytest{
public class Conn:Page{
int pageSize,currentPage;
string connStr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(".") + ConfigurationSettings.AppSettings["dbpath"];
private void Page_Load(object sender EventArgs e){
pageSize=5;
currentPage=10;
OleDdconnection conn = new OleDbconnection(connStr)
string selectStr = "select * from GuestBook order by id desc"
conn.Open();
OleDbDataAdapter da= new OleDbDataAdpater(selectStr,conn);
DataSet ds = new DataSet;
da.Fill(ds,currentPage*pageSize,pageSize,"Message");
message.DataSource=ds;
message.DataMember="Message";
message.DataBind();

}
}

}

<asp:repeater id="message" runat="server">
<itemtemplate>
<% DataBinder.Eval(Container.DataItem,"Data")%>
</itemtemplate>
</asp:repeater>