在web页面上放一些变量,如总页数,当前页,每页条数,这样等客户端选择新的页面后在服务器端可以根据这些值生成Sql语句,取出数据重新绑定了。 Sql语句使用子查询如: strSQL = "SELECT TOP "+pagesize+" SoftID,SoftName,SoftEdition,SoftOrders," +"SoftKind,SoftSystem, AddTime ,AllHits,SoftGrade,SoftNote,DClassID,MClassID FROM RYnet_DownLoad " +"WHERE softID in (SELECT TOP "+fillcounts+" softID FROM RYnet_DownLoad WHERE MClassID= ? ORDER BY softID DESC ) " +"ORDER BY softID ASC";
然后再cs文件中使用PageIndexChange事件
private void datagrid_PageIndexChange(……)
{
this.datagrid.currentPage=e.newPage.
//在重行邦定数据
}
Sql语句使用子查询如:
strSQL = "SELECT TOP "+pagesize+" SoftID,SoftName,SoftEdition,SoftOrders,"
+"SoftKind,SoftSystem, AddTime ,AllHits,SoftGrade,SoftNote,DClassID,MClassID FROM RYnet_DownLoad "
+"WHERE softID in (SELECT TOP "+fillcounts+" softID FROM RYnet_DownLoad WHERE MClassID= ? ORDER BY softID DESC ) "
+"ORDER BY softID ASC";
控制进行“上一条”,“下一条”移动