if(pagecurrent==1) { select top 14* from (select pagesize*(currentpage-1) from table where + strwhere); } else { select top 12* from (select pagesize*(currentpage-1) from table where + strwhere); } 没有测试
if(pagecurrent==1) { select top 14* from (select top* pagesize*(currentpage-1) from table where + strwhere); } else { select top 12* from (select top* pagesize*(currentpage-1) from table where + strwhere); }
你的分页是自定义分页(AspnetPager或ObjectDataSource结合存储过程),还是默认的分页?某页是指明哪一页?随机指定?下一页的2个记录在翻到下一页时继续显示还是pass?
然后到邦定的数据源中逐条向后做判断,
protected void PagerButtonClick(object sender, EventArgs e)
{
GridView1.PageIndex = Convert.ToInt32(((LinkButton)sender).CommandName)-1;
GridViewBind("");
}这个GridViewBind("")中执行
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataBind();所绑定要显示的数据是控件自动根据PageIndex 来判定的?
{
select top 14* from (select pagesize*(currentpage-1) from table where + strwhere);
}
else
{
select top 12* from (select pagesize*(currentpage-1) from table where + strwhere);
}
没有测试
{
select top 14* from (select top* pagesize*(currentpage-1) from table where + strwhere);
}
else
{
select top 12* from (select top* pagesize*(currentpage-1) from table where + strwhere);
}