AspNETPager分页的用法

现在的位置: 首页 > 综合 > 正文

AspNETPager分页的用法

2013年07月02日 ⁄ 综合 ⁄ 共 2056字 ⁄ 字号小中大 ⁄ 评论关闭

<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();
     }

}