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.
7 Answers, 1 is accepted
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.
the Telerik team
are there any workaround for that.
I am afraid I could not provide you with a workaround for this scenario.
the Telerik team
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.
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.
I would suggest you check the following help article which could help you to increase the performance of the RadGridView. RadVirtualGrid control instead. The control can operate with a huge amount of data without any performance degradation. It supports filtering and sorting functionalities.