Dear,
If you want to retrieve the data with costume paging(means retrieve some set of records instead of whole records from database), then i am providing a procedure which must help you. Then you can use your logic for how much records you want to show on your page and how.
CREATE PROCEDURE GETDATA
(
@StartRowIndex INT,
@MaxmumRows INT
)
AS BEGIN
SET @StartRowIndex = (@StartRowIndex * @MaxmumRows)
SELECT * FROM
(
SELECT *, ROW_NUMBER() OVER(ORDER BY ID DESC) AS RowRank FROM MyTable
) AS MyTable WHERE RowRank > @StartRowIndex AND RowRank <= (@StartRowIndex + @MaxmumRows)
END