Show several pagination pages but only query what the user see

3 posts, 0 answers
  1. Rolland
    Rolland avatar
    6 posts
    Member since:
    Sep 2016

    Posted 20 Oct 2016 Link to this post


    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 :)



  2. Viktor Tachev
    Viktor Tachev avatar
    2469 posts

    Posted 25 Oct 2016 Link to this post

    Hello Rolland,

    In order to implement the functionality you should use Custom Paging. This way you can return only the relevant items from the data source of the Grid.

    Check out the following resources that describe the functionality in more detail. You can also see a live example on how Custom Paging works.

    Viktor Tachev
    Telerik by Progress
    Check out the new UI for ASP.NET Core, the most complete UI suite for ASP.NET Core development on the market, with 60+ tried-and-tested widgets, based on Kendo UI.
  3. Rolland
    Rolland avatar
    6 posts
    Member since:
    Sep 2016

    Posted 25 Oct 2016 in reply to Viktor Tachev Link to this post

    Thanks Viktor, 


    The VirtualItemCount  was exactly what I needed !


Back to Top