- <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" OnPageChanging="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, 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();
- }
- }