radgrid custom grouping when custom paging

[Dimuthu]

http://demos.telerik.com/aspnet-ajax/grid/examples/programming/custompaging/defaultcs.aspx
when i group this by Name column it only shows one grouping header even when it is collapsed. how can i show other grouping headers too.

[Kostadin]

Hi Dimuthu,

This behavior is expected because the grid fetch merely part from the records at a time to execute requested operation. If you want to show all groups you have to fetch all record from the data source.

Regards,
Kostadin
the Telerik team

[Dimuthu]

thanks kostadin. but if the record count is too large and db is not over the same network. it will take considerable time to fetch data. 
are there any workaround for that.
.

[Kostadin]

Hello Dimuthu,

I am afraid I could not provide you with a workaround for this scenario.

Regards,
Kostadin
the Telerik team

[Himanshu]

Hi,

I have 2 million record in ObservableCollection<> and I bind this collection with the radgridview. When I filtered the data with gridview filters, grid takes time to process and it takes time on paging with raddatapager, same thing happens in sorting the column. Can anyone help please. 

[Marin Bratanov]

Hi Himanshu,

The built-in filtering of RadGrid for ASP.NET AJAX requires that it has all the records and then it uses filtering in-memory. Thus, optimizing the data retrieval logic is the best way to optimize those queries.

Alternatively, you can use the ItemCommand event, capture the filter command and cancel the event, so you can .Rebind() the grid and filter the data prior to giving it to the grid so you can perform the filtering operations as your data source level. You can find the basics in the following article: https://docs.telerik.com/devtools/aspnet-ajax/controls/grid/how-to/Filtering/operate-with-the-filterexpression-manually.

Another approach is to use RadFilter to build up a query for the SqlDataSource (or other declarative data source): https://demos.telerik.com/aspnet-ajax/filter/examples/integration/defaultcs.aspx?product=filter.

A third approach is to build up a set of filter controls that provide filter parameters to the data source, like the combo box is used in this example: https://demos.telerik.com/aspnet-ajax/controls/examples/integration/gridcomboajax/defaultcs.aspx?product=combobox.

Regards,
Marin Bratanov
Progress Telerik

[Himanshu]

Sorry I Forgot to mention that the project is in WPF!.

[Dinko | Tech Support Engineer]

Hello Himanshu,

I would suggest you check the following help article which could help you to increase the performance of the RadGridView.

• Degraded Performance 
• Tips and Tricks

You can try some of the suggestion mentioned in these articles. Basically, showing such a large number of times is kind of expected to be a performance hit. For a large number of items, you can consider using RadVirtualGrid control instead. The control can operate with a huge amount of data without any performance degradation. It supports filtering and sorting functionalities.

Regards,
Dinko
Progress Telerik