int iPage=0;
............
............
btn_NextPage_click(object sender,EventArgs)//点击下一页的按钮
{
this.iPage+=1;
string strSql="Select Top 100 * From Table where ID>iPage*100 and id<=
"+((iPage+1)*100).ToString()+ "order by ID.
//通过上面的Sql语句把数据读入DataSet或DataTable.在显示出来
...
//
}
............
............
btn_NextPage_click(object sender,EventArgs)//点击下一页的按钮
{
this.iPage+=1;
string strSql="Select Top 100 * From Table where ID>iPage*100 and id<=
"+((iPage+1)*100).ToString()+ "order by ID.
//通过上面的Sql语句把数据读入DataSet或DataTable.在显示出来
...
//
}
----------------
id如果不是连续的(或者中间有被删除的),用这个代码取出来的结果就不对了建议用存储过程,只取当前页需要的记录即可。我这里有1667751条记录,你看一下分页效果如何?http://search.newsfan.net/?q=csdn&j=0