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.