Server side paging

6 posts, 0 answers
  1. Alexander
    Alexander avatar
    4 posts
    Member since:
    Jun 2014

    Posted 08 Jun 2016 Link to this post

    Hi,

     

    Is it possible to use paging and just retrieve data for each page (i.e if you go to a new page the data for that page will be loaded)?

     

    The issue i'm having right now is that the result from the server (currently with WCF) has contain all the records in order for the paging to work, however, I dont want to send all the data at once.

     

    Maybe there is a way to manipulate the TotalPages-property to think it has more data in the result?

  2. Dess | Tech Support Engineer, Sr.
    Admin
    Dess | Tech Support Engineer, Sr.  avatar
    3626 posts

    Posted 08 Jun 2016 Link to this post

    Hello Alexander,

    Thank you for writing. 

    It is appropriate to use RadVirtualGrid which provides a convenient way to implement your own data management operations and optimizes the performance when interacting with large amounts of data. Thus, the rows for the relevant page will be requested when the certain page is current and you can populate a value in the CellValueNeeded event.
    Please refer to our Demo application >> VirtualGrid >> Paging example.

    I hope this information helps. Should you have further questions I would be glad to help.

    Regards,
    Dess
    Telerik
    Check out the Windows Forms project converter, which aids the conversion process from standard Windows Forms applications written in C# or VB to Telerik UI for WinForms.For more information check out this blog post and share your thoughts.
  3. Aseman
    Aseman avatar
    38 posts
    Member since:
    Aug 2019

    Posted 02 Sep 2019 Link to this post

    hello Dess

    paging in radgridview is client side or server side?

    i guess it`s client side,so how can i do it on server side? 

    thank you for your attention

  4. Dess | Tech Support Engineer, Sr.
    Admin
    Dess | Tech Support Engineer, Sr.  avatar
    3626 posts

    Posted 03 Sep 2019 Link to this post

    Hello, Aseman,  

    Indeed, the paging functionality in RadGridView is client-side. RadGridView contains all data in its DataSource collection and the paging just represents the records in a suitable UI.

    The possible solution that I can suggest for server-side paging is RadVirtualGrid. a grid component developed on top of Telerik Presentation Framework which provides a convenient way to implement your own data management operations and optimizes the performance when interacting with large amounts of data. The data layer of RadVirtualGrid supports pagination of data natively. Enabling the paging functionality does not change the way the virtual grid works. You can refer to the following help article demonstrating how RadVirtualGrid is populated with data: https://docs.telerik.com/devtools/winforms/controls/virtualgrid/working-with-data/virtualgrid-populating-with-data

    I hope this information helps. 

     

    Regards,
    Dess | Tech Support Engineer, Sr.
    Progress Telerik

    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
  5. Aseman
    Aseman avatar
    38 posts
    Member since:
    Aug 2019

    Posted 15 Dec 2019 in reply to Dess | Tech Support Engineer, Sr. Link to this post

    excuse me.

    Do You have Sample of implementing Serverside  paginaion in radGridView In Winform By OffSet and Fetch in SqlQuery?

  6. Dess | Tech Support Engineer, Sr.
    Admin
    Dess | Tech Support Engineer, Sr.  avatar
    3626 posts

    Posted 16 Dec 2019 Link to this post

    Hello, Aseman,    

    RadGridView doesn't offer server-side paging functionality. 

    That is why I have suggested you to use RadVirtualGrid which loads data on demand in the CellValueNeeded. Whenever you scroll the grid or navigate to a new page, the CellValueNeeded event is fired requesting the data to be loaded in the current view. 

    You can refer to our Demo application >> VirtualGrid >> Paging example. The Demo application can be found in the installation folder of the suite. 
    The VirtualGrid >> Web Service example is quite useful about loading data when it is requested using the busy indicator in RadVirtualGrid.

    Should you have further questions please let me know.

     

    Regards,
    Dess | Tech Support Engineer, Sr.
    Progress Telerik

    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Back to Top