This is a migrated thread and some comments may be shown as answers.

Data paginate using LIMIT/OFFSET

0 Answers 69 Views
GridView
This is a migrated thread and some comments may be shown as answers.
gerardo
Top achievements
Rank 1
Veteran
gerardo asked on 19 Jul 2020, 04:44 AM

Good day.

How can I have a paginated GridView using SQL LIMIT/OFFSET.

I tried using DataPager and GridView but what i understand is the control loads the records in full. Is it possible to have the Pager or the GridView use something like LIMIT/OFFSET when retrieving the date from the database.

For example 1 have 100,000 records. I just want to load the first 1000 on my page load and navigate via pager(with 100 page indicator) to show the other records. And also have it affect the GridView column filter and other header controls which means when I filter/sort it will look on the full records list. 

 

Thank you very much.

No answers yet. Maybe you can help?

Tags
GridView
Asked by
gerardo
Top achievements
Rank 1
Veteran
Share this question
or