我有一个AspNetPager控件,页面代码如下
<webdiyer:aspnetpager id="AspNetPager1" runat="server" alwaysshow="True" firstpagetext="首页"
lastpagetext="尾页" nextpagetext="下一页" prevpagetext="上一页" showinputbox="Always"
onpagechanged="AspNetPager1_PageChanged" showboxthreshold="10" pagesize="20"
width="356px">
</webdiyer:aspnetpager>后置代码如下: protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (NewsBLL.GetNewsCount() > 0)
{
AspNetPager1.RecordCount = NewsBLL.GetNewsCount();//新闻总数
BindNews(AspNetPager1.RecordCount, AspNetPager1.PageSize);
}
}
}
//绑定新闻
protected void BindNews(int number, int pagesize)
{
List<News> list = NewsBLL.GetArticleListPageNo(number, pagesize);
this.GridView1.DataSource = list;
this.GridView1.DataBind(); }
protected void AspNetPager1_PageChanged(object sender, EventArgs e)
{
//AspNetPager pa=(AspNetPager)sender;
//AspNetPager1.CurrentPageIndex = pa.CurrentPageIndex;
//要减去的记录数
int subtract_number = AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1);
//要获取的记录数:记录总数-要减去的记录数
int number = AspNetPager1.RecordCount - subtract_number;
BindNews(number, AspNetPager1.PageSize);
}数据层分页语句如下:
/// <summary>
/// 获取新闻列表分页
/// </summary>
/// <param name="number">新闻信息总数</param>
/// <param name="pagesize">每页大小</param>
/// <returns></returns>
public static List<News> GetArticleListPageNo(int number, int pagesize)
{
string sqlStr = "select top " + pagesize + " * from (select top " + number + " * from News order by [Order] asc) order by [Order] desc"; List<News> list = new List<News>();首页我要声明:别跟我说一些别的方法,就用这个,主要是这个语句,别人也是这样写的怎么没问题;真心想帮我的就好好看;混分的速度走远
<webdiyer:aspnetpager id="AspNetPager1" runat="server" alwaysshow="True" firstpagetext="首页"
lastpagetext="尾页" nextpagetext="下一页" prevpagetext="上一页" showinputbox="Always"
onpagechanged="AspNetPager1_PageChanged" showboxthreshold="10" pagesize="20"
width="356px">
</webdiyer:aspnetpager>后置代码如下: protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (NewsBLL.GetNewsCount() > 0)
{
AspNetPager1.RecordCount = NewsBLL.GetNewsCount();//新闻总数
BindNews(AspNetPager1.RecordCount, AspNetPager1.PageSize);
}
}
}
//绑定新闻
protected void BindNews(int number, int pagesize)
{
List<News> list = NewsBLL.GetArticleListPageNo(number, pagesize);
this.GridView1.DataSource = list;
this.GridView1.DataBind(); }
protected void AspNetPager1_PageChanged(object sender, EventArgs e)
{
//AspNetPager pa=(AspNetPager)sender;
//AspNetPager1.CurrentPageIndex = pa.CurrentPageIndex;
//要减去的记录数
int subtract_number = AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1);
//要获取的记录数:记录总数-要减去的记录数
int number = AspNetPager1.RecordCount - subtract_number;
BindNews(number, AspNetPager1.PageSize);
}数据层分页语句如下:
/// <summary>
/// 获取新闻列表分页
/// </summary>
/// <param name="number">新闻信息总数</param>
/// <param name="pagesize">每页大小</param>
/// <returns></returns>
public static List<News> GetArticleListPageNo(int number, int pagesize)
{
string sqlStr = "select top " + pagesize + " * from (select top " + number + " * from News order by [Order] asc) order by [Order] desc"; List<News> list = new List<News>();首页我要声明:别跟我说一些别的方法,就用这个,主要是这个语句,别人也是这样写的怎么没问题;真心想帮我的就好好看;混分的速度走远
如果你什么事情都没有做过 只是从别人那里复制来了一段代码 不能分页 那请你虚心点请教 别那么拽
跑过来不能学习下,不过看你那鸡巴代码,也没那必要了