AspNETPager的用法

最新推荐文章于 2021-01-10 20:20:47 发布

lmh27730536

最新推荐文章于 2021-01-10 20:20:47 发布

阅读量239

点赞数

分类专栏： ASP.NET类文章标签： server asp

本文链接：https://blog.csdn.net/lmh27730536/article/details/3691098

版权

ASP.NET类专栏收录该内容

23 篇文章 0 订阅

订阅专栏

 
 <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>
 

后置代码:default.aspx.cs

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

lmh27730536

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
AspNETPager的用法

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="ser
复制链接

扫一扫

专栏目录