asp.net 存储过程带参分页实现

Question

存储过程如下:

ALTER PROCEDURE [dbo].[p_User_GetPage]
(
    @pageIndex int,--
    @pageSize int --
)
AS
set nocount on
select * 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......