Server side paging in UI for WinForms GridView

Alexander

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?

Dess | Tech Support Engineer, Sr.

Admin

4169 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.

Aseman

43 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

Dess | Tech Support Engineer, Sr.

Admin

4169 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.

Aseman

43 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?

Dess | Tech Support Engineer, Sr.

Admin

4169 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.

Shaun

39 posts

Member since:
Sep 2012

Posted 23 Jun 2020 Link to this post

Hi,

I'm looking to improve data load by using paging, is there any tricks to convert from dataview to virtualGrids as I have lots of them through my application

Cheers

Shaun

Dess | Tech Support Engineer, Sr.

Admin

4169 posts

Posted 23 Jun 2020 Link to this post

Hi, Shaun,

RadGridView and RadVirtualGrid are two different controls with their internal specific implementation. It wouldn't be easy to provide automatic conversion from RadGridView to RadVirtualGrid. It has to be done manually.

RadVirtualGrid is a control that allows you to display and edit tabular data from any kind of data source and large number of records. In order to fill RadVirtualGrid with data, you should follow the steps below:

1. Handle the CellValueNeeded event. You should specify the Value argument in the VirtualGridCellValueNeededEventArgs.

2. You will also need to set the RowCount and ColumnCount properties so that the grid will know how many rows/columns it needs to display.

Additional information and a sample code snippet is available in the following help article: https://docs.telerik.com/devtools/winforms/controls/virtualgrid/working-with-data/virtualgrid-populating-with-data

RadVirtualGrid also support paging. It is necessary to enable the EnablePaging property.

I hope this information helps. If you need any further assistance please don't hesitate to contact me.

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

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.