AspNetPager 三层分页

来源：互联网发布：php 怎么去掉html标签编辑：程序博客网时间：2024/04/28 08:16

.aspx

<webdiyer:AspNetPager ID="AspNetPager1" runat="server" AlwaysShow="True"
 FirstPageText="首页" LastPageText="尾页" NextPageText="下一页"
 onpagechanged="AspNetPager1_PageChanged"
 onpagechanging="AspNetPager1_PageChanging" PageSize="5" PrevPageText="上一页"
 ShowInputBox="Always" UrlPaging="True" CustomInfoHTML="共 %RecordCount% 条记录当前 %CurrentPageIndex%/%PageCount% 页"
 ShowCustomInfoSection="Left">

CustomInfoHTML="共 %RecordCount% 条记录当前 %CurrentPageIndex%/%PageCount% 页"

.aspx.cs

private void BindDatabale()
    {
        int iPageIndex = AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1);
        int iPageSize = AspNetPager1.PageSize;
        DataSet dt = NewsServer.GetDataSet(iPageIndex,iPageSize);

//lblValue.Text = dt.Rows.Count.ToString();
lblValue.Text = dt.Tables.Count.ToString();

AspNetPager1.RecordCount = Convert.ToInt32(NewsServer.GetCount().ToString());
//PagedDataSource pds = new PagedDataSource();

        //pds.DataSource = dt.Tables;
        //pds.PageSize = AspNetPager1.PageSize ;
        //pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
        DataList1.DataSource = dt;
        this.DataList1.DataBind();

}

--- 第二中方式直接查询出所有的数据

        private void BindHot()
        {
            PagedDataSource pds = new PagedDataSource();
            pds.DataSource = bll.GetInfoHot().DefaultView;
            this.AspNetPager2.RecordCount = pds.Count;
            pds.AllowPaging = true;
            pds.PageSize = this.AspNetPager2.PageSize;
            pds.CurrentPageIndex = this.AspNetPager2.CurrentPageIndex - 1;
            DataList1.DataSource = pds;
            DataList1.DataBind();
        }

protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
    {
        AspNetPager1.CurrentPageIndex = e.NewPageIndex;
        BindDatabale();
    }

.cs

public static DataSet GetDataSet(int pageIndex, int pageSize)
        {
            string strSql = "select * from News";
            SqlConnection conn = new SqlConnection(strConnection);
            conn.Open();
            SqlCommand cmd = new SqlCommand(strSql, conn);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds, pageIndex, pageSize, "News");
            return ds;
        }

sql:

string strSql = "select top " + pager.PageSize + " * from tb where id not in (select top " + (pager.CurrentPageIndex - 1) * pager.PageSize + " id from tb order by id DESC) order by id DESC";

使用手动sql分页

select top (@pageNum) * from table where ID
not in(select top (@pageNum*(@pageNo-1)) ID from table order by WriteTime desc)
order by WriteTime desc

使用aspnetPager的sql语句：

pageNo //显示过的数据

pageNum//显示多少条数据

select top (@pageNum) * from table where ID
not in(select top (@page

使用手动sql分页

select top (@pageNum) * from table where ID
not in(select top (@pageNum*(@pageNo-1)) ID from table order by WriteTime desc)
order by WriteTime desc

使用aspnetPager的sql语句：

pageNo //显示过的数据

pageNum//显示多少条数据

select top (@pageNum) * from table where ID
not in(select top (@pageNo) ID from table order by WriteTime desc)
order by WriteTime descNo) ID from table order by WriteTime desc)
order by WriteTime desc

0 0