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

radgrid custom grouping when custom paging

7 Answers 36 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Dimuthu
Top achievements
Rank 1
Dimuthu asked on 29 Mar 2013, 03:34 AM
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.

7 Answers, 1 is accepted

Sort by
0
Kostadin
Telerik team
answered on 02 Apr 2013, 12:00 PM
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
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Dimuthu
Top achievements
Rank 1
answered on 03 Apr 2013, 03:11 AM
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.
.
0
Kostadin
Telerik team
answered on 08 Apr 2013, 06:56 AM
Hello Dimuthu,

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

Regards,
Kostadin
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Himanshu
Top achievements
Rank 1
answered on 01 Feb 2019, 11:44 AM

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. 

0
Marin Bratanov
Telerik team
answered on 04 Feb 2019, 03:54 PM
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
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
Himanshu
Top achievements
Rank 1
answered on 05 Feb 2019, 05:05 AM
Sorry I Forgot to mention that the project is in WPF!.
0
Dinko
Telerik team
answered on 07 Feb 2019, 03:54 PM
Hello Himanshu,

I would suggest you check the following help article which could help you to increase the performance of the RadGridView. 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
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.
Tags
Grid
Asked by
Dimuthu
Top achievements
Rank 1
Answers by
Kostadin
Telerik team
Dimuthu
Top achievements
Rank 1
Himanshu
Top achievements
Rank 1
Marin Bratanov
Telerik team
Dinko
Telerik team
Share this question
or