Hello All,
First Issue
I am trying to use RadGrid and the data source for this comes from a webapi. I have successfully added the data to the RadGrid. But, the issues is that there are over 10,000 records the api returns and takes 20-30 min to load the RadGrid. To make things easy on data binding and loading, I have tried to create dynamic RadGrid. The idea is to call the api and return only 50 records on every page change. The pagination wont show because, I am retrieving only 50 records every time. So the first page shows up with 50 records and I cannot paginate as there are no pages showing up.
2nd issue
I need to add a search box and allow searching for a record. I could achieve this when I created radgrid using ASPX. But, dynamic creation of radgrid, I have to call the api's every time and load the grid again and then search for the data which (according to me) is inefficient. The same with export to CSV. I have to recreate the radgrid every time.
Are there any better ways to do this without dynamic radgrid, and still be able to paginate and call the api when ever the next page is clicked. I am using C#. I understand it will be hard for you all to picture what I am trying to say, but, I really appreciate any help or suggestions or questions that guide me in the right direction.
Thank you in advance
First Issue
I am trying to use RadGrid and the data source for this comes from a webapi. I have successfully added the data to the RadGrid. But, the issues is that there are over 10,000 records the api returns and takes 20-30 min to load the RadGrid. To make things easy on data binding and loading, I have tried to create dynamic RadGrid. The idea is to call the api and return only 50 records on every page change. The pagination wont show because, I am retrieving only 50 records every time. So the first page shows up with 50 records and I cannot paginate as there are no pages showing up.
2nd issue
I need to add a search box and allow searching for a record. I could achieve this when I created radgrid using ASPX. But, dynamic creation of radgrid, I have to call the api's every time and load the grid again and then search for the data which (according to me) is inefficient. The same with export to CSV. I have to recreate the radgrid every time.
Are there any better ways to do this without dynamic radgrid, and still be able to paginate and call the api when ever the next page is clicked. I am using C#. I understand it will be hard for you all to picture what I am trying to say, but, I really appreciate any help or suggestions or questions that guide me in the right direction.
Thank you in advance
2 Answers, 1 is accepted
0
Hi Satish,
Based on your description I would suggest two possible approaches that you could use to achieve the desired functionality.
Regards,
Antonio Stoilkov
Telerik
Based on your description I would suggest two possible approaches that you could use to achieve the desired functionality.
- Custom Paging which allows you to set a VirtualItemCount that sets the items that the RadGrid should be bound to but you only need to bind the items for the current page as shown in the demo below
- http://demos.telerik.com/aspnet-ajax/grid/examples/programming/custompaging/defaultcs.aspx
- Virtualization - the functionality enables you to bind to huge amount of data and does not suffer performance hits. The idea behind the feature is binding only the visible rows and requesting data when needed by firing a callback. This approach will allow you to call the WebAPI on the client and bind the RadGrid on the client and resolve the issue with going back to the server for searching
- http://demos.telerik.com/aspnet-ajax/grid/examples/performance/virtualization/defaultcs.aspx
Regards,
Antonio Stoilkov
Telerik
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 the blog feed now.
0
Smart
Top achievements
Rank 1
Rank 1
answered on 06 Nov 2013, 05:28 PM
Thank you Antonio
I went about using Custom Paging, because Virtualization is only available on Telerik 2013 version. I using 2012. But nevertheless it custom paging worked.
I have another issues with paging please see the link below, when you get time
http://www.telerik.com/community/forums/aspnet-ajax/grid/paging-backward-goes-back-to-page-1.aspx
I went about using Custom Paging, because Virtualization is only available on Telerik 2013 version. I using 2012. But nevertheless it custom paging worked.
I have another issues with paging please see the link below, when you get time
http://www.telerik.com/community/forums/aspnet-ajax/grid/paging-backward-goes-back-to-page-1.aspx