存儲過程如下:
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......
asp.net 存儲過程帶參分頁實現
慕田峪9158850
2018-12-07 12:02:37