<html xmlns="http://www.w3.org/1999/xhtml" ><head runat="server"> <title>无标题页</title></head><body> <form id="form1" runat="server"> <div> <asp:DataList ID="DataList1" runat="server"> <ItemTemplate> ProductName: <asp:Label ID="ProductNameLabel" runat="server" Text='<%# Eval("ProductName") %>'> </asp:Label><br /> <br /> </ItemTemplate> </asp:DataList> <webdiyer:aspnetpager id="pager1" runat="server" onpagechanged="ChangePage"></webdiyer:aspnetpager> </div> </form></body></html>
using System;using System.Data;using System.Configuration;using System.Collections;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 cpp114.tools.oledb;using System.Data.OleDb;using Wuqi.Webdiyer;public partial class test_Default : System.Web.UI.Page
{
protected OleDbConnection conn = new OleDbConnection(); protected OleDbCommand cmd = new OleDbCommand(); protected void Page_Load(object sender, EventArgs e)
{ if (!IsPostBack) { initdb(); conn.Open(); cmd.CommandText = "select count(*) from t_product"; pager1.RecordCount = (int)cmd.ExecuteScalar(); conn.Close(); BindData(); 
} }//初始化连接对象 protected void initdb(){ conn.ConnectionString = oledbtool.myConnStr + Server.MapPath(oledbtool.mydbName); cmd.Connection = conn; }//数据绑定 protected void BindData() { initdb(); OleDbDataAdapter sda = new OleDbDataAdapter("select * from t_product",conn); DataSet ds = new DataSet(); //sda.Fill(ds, 10, 10, "temptbl"); sda.Fill(ds, pager1.PageSize * (pager1.CurrentPageIndex - 1), pager1.PageSize, "temptbl"); DataList1.DataSource = ds.Tables["temptbl"]; DataList1.DataBind(); }//翻页事件 protected void ChangePage(object src, PageChangedEventArgs e) { pager1.CurrentPageIndex = e.NewPageIndex; BindData(); } 
}