I have a problem where I pull data from a huge database (over 140 000 entries) and have taken care to do my own pagination to limit loading time for my users.
Basically, on pagination changes (next, prev, click on number etc.) I query my own 20 rows (which is pagesize) to fill up only what the user see and not pull tens of thousands of rows each time which would slow down the user's experience.
So my problem is, if I do it this way, my table only shows my 20 rows and not whats available to the user.
I have a line in my codebehind that returns the number of results I would like to tell RadGrid is available:
var querySize = bllUsNet.ObtenirTout().Count;
Is there a way to "Trick" Radgrid into thinking there is that many entries but only return 20 ?
If anyone has an idea of a better title for this thread, I had a hard time to find one :)