This is a migrated thread and some comments may be shown as answers.

Server side paging

8 Answers 416 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Alexander
Top achievements
Rank 1
Alexander asked on 08 Jun 2016, 11:31 AM

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?

8 Answers, 1 is accepted

Sort by
0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 08 Jun 2016, 12:00 PM
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.
0
Aseman
Top achievements
Rank 1
Veteran
answered on 02 Sep 2019, 12:45 PM

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

0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 03 Sep 2019, 10:47 AM
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.
0
Aseman
Top achievements
Rank 1
Veteran
answered on 15 Dec 2019, 11:05 AM

excuse me.

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

0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 16 Dec 2019, 12:47 PM
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.
0
Shaun
Top achievements
Rank 1
answered on 24 Jun 2020, 03:21 AM

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

 

 

0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 24 Jun 2020, 04:52 AM

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.
0
Giovanni
Top achievements
Rank 1
Iron
Iron
Iron
answered on 24 Oct 2023, 03:34 PM

Hi Dess, I'm trying to use RadVirtualGrid to load a big amount of data.

I've implemented server-side paging and sorting.

Now UI want to implement server side filtering, but now it seems to me that the component is limited.

Can I customize filters in any way, like I can do with RadGridView?

I'm interested in a solution like the example "Excel like filtering".

 

Thank you

Dinko | Tech Support Engineer
Telerik team
commented on 25 Oct 2023, 11:24 AM

Thank you for your interest in our RadVirtualGrid control.

Excel-like filtering is supported only in RadGridView as it needs the whole data to extract the distinct values for a column. Then, it filters the available options available in the rest of the columns for filtering. Such functionality is not intended to be supported in our RadVirtualGrid due to the specificity of the data management. You can check the RadVirtualGrid Filtering article to get familiar with the currently supported filtering of the control.


Giovanni
Top achievements
Rank 1
Iron
Iron
Iron
commented on 26 Oct 2023, 06:32 AM

Hi Dinko, thank you.

I'm oriented to use RadVirtualGrid cause I have a big number of record to show, but filtering in this case is very limited.

It seems to me that no customization is possible, is it right?

I can only choose an operator (contains, equal, etc) and digit a value in a textbox, even for column whit date o numbers... No DatetimePicker is avaliable to enter a date...

And again, a FilterChanged event is raised on each char digited, so I need to execute a new query for each char!

Is there any way to customize filters?

In your demo program you proposed the DataFilter obejct, but it seems to me not too immediate for user used to Excel-Access-like filters.

Thank you!

Dinko | Tech Support Engineer
Telerik team
commented on 30 Oct 2023, 12:29 PM

Note that RadVirtualGrid does not load the entire data, it only requests the data that should be currently visible. That is why this control does not provide Excel-like filtering. This kind of filtering will need to get all the data, not only the visible one. Also, the default filter cell will always be a text box. However, you could create a custom VirtualGridFilterCellElement in which you can add RadDateTimePickerElement. We could subscribe to its ValueChanged event and manually add the FilterDescriptor. You could read the Create Custom Cell article which I used to create the custom filter cell. To better demonstrate what I have in mind, I am sharing my test project. You can use it as a starting point and modify the approach inside and cover your requirements. I need to point out that this approach is completely custom and any further customization needs to be performed on your side.

 

Giovanni
Top achievements
Rank 1
Iron
Iron
Iron
commented on 02 Nov 2023, 07:02 AM

Hi Dinko, thank you.

We changed idea and decided to use RadGridView.

Thank you anyway.

Tags
GridView
Asked by
Alexander
Top achievements
Rank 1
Answers by
Dess | Tech Support Engineer, Principal
Telerik team
Aseman
Top achievements
Rank 1
Veteran
Shaun
Top achievements
Rank 1
Giovanni
Top achievements
Rank 1
Iron
Iron
Iron
Share this question
or