AspNetPager 三层分页

.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="共 &lt;font color=&quot;red&quot;&gt;%RecordCount%&lt;/font&gt; 条记录 当前 &lt;font color=&quot;red&quot;&gt;%CurrentPageIndex%/%PageCount%&lt;/font&gt; 页"
                ShowCustomInfoSection="Left">

 CustomInfoHTML="共 &lt;font color=&quot;red&quot;&gt;%RecordCount%&lt;/font&gt; 条记录 当前 &lt;font color=&quot;red&quot;&gt;%CurrentPageIndex%/%PageCount%&lt;/font&gt; 页"

.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