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
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
Rank 1
Veteran
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
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
Rank 1
Veteran
excuse me.
Do You have Sample of implementing Serverside paginaion in radGridView In Winform By OffSet and Fetch in SqlQuery?
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
Rank 1
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
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
Our thoughts here at Progress are with those affected by the outbreak.
Rank 1
Iron
Iron
Iron
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
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.
Rank 1
Iron
Iron
Iron
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!
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.
Rank 1
Iron
Iron
Iron
Hi Dinko, thank you.
We changed idea and decided to use RadGridView.
Thank you anyway.