存储过程如下:
ALTER PROCEDURE [dbo].[p_User_GetPage]( @pageIndex int,-- @pageSize int --)ASset nocount onselect * from ( select id,userName,gender,Row_NUMBER() over ( order by id desc) as ROWNUM from t_user ) row_user where row_user.RowNum between (@pageIndex*@pageSize+1) and ((@pageIndex+1)*@pageSize)order by id
怎么在页面中调用,实现分页功能,可以跟控件实现:如GridView......
1 回答
- 1 回答
- 0 关注
- 427 浏览
添加回答
举报
0/150
提交
取消