[转帖]DataGrid的自定义分页UserControl

[转帖]DataGrid的自定义分页UserControl(31)         #endregion
    }

}
=================================================================
存储过程:
Create PROCEDURE dbo.Page_Change
/*
    (
        @parameter1 datatype = default value,
        @parameter2 datatype OUTPUT
    )
*/
(
@PageSize int,
@CurrentPage int
)

AS
    /* SET NOCOUNT ON */
    
    select *,IDENTITY(int,1,1) as Num into #TempAuthors from Authors
    
    select * from #TempAuthors where Num > (@PageSize*@CurrentPage) and Num < (@PageSize*@CurrentPage+@PageSize+1)
    
    RETURN