Pagination without using jquery

sankeerth m

Hi team, I am working on pagination while executing 20k records the page is loading 20k records and then pagination is working from Jquery Ui. But how can execute when i click on the page number it should hit to db and i need to get records. Can please help me out. Thanks in advance.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sreekanth Reddy6y ago
Hi sankeerth m
Please follow the concept of "Pagination in SQL Server"
CREATE PROCEDURE dbo.Pagination_Test_1 -- ORDER BY CustomerID
  @PageNumber INT = 1,  --user hitting page number from front end
  @PageSize   INT = 100  --User selected no of rows in front end.
AS
BEGIN
  SET NOCOUNT ON;

  SELECT CustomerID, FirstName, LastName,
      EMail, Active, Created, Updated
    FROM dbo.Customers_I
    ORDER BY CustomerID
    OFFSET @PageSize * (@PageNumber - 1) ROWS
    FETCH NEXT @PageSize ROWS ONLY OPTION (RECOMPILE);
END
GO
If it helps, Mark as answer. Else come up with your queries.
Thank you.
Joginder Banger6y ago
Hi sankeerth,

I think you have a jquery gridview and you need some override functionality. Please check in your gridview generic function, hopefully it may be provide. you need the page number and page size.

SQL query
SELECT col1, col2, ...
FROM ...
WHERE ...
ORDER BY -- this is a MUST there must be ORDER BY statement
-- the paging comes here
OFFSET     10 ROWS       -- skip 10 rows
FETCH NEXT 10 ROWS ONLY; -- take 10 rows
I hope you got the idea, how can achive this.

Thanks
JSB