Binding Large dataSet to radgrid

1 Answer 37 Views
Grid
Itamar
Top achievements
Rank 1
Iron
Iron
Itamar asked on 20 May 2021, 09:28 AM

Hi,

Im trying to bind a large data set with thousands of rows ,to a rad grid but I dont want to do it all at once,I want for example the pager to call lets say 15 rows at a time from the database and display those then the next page will call and display another 15....

Any help would be appreciated thanks.

 

1 Answer, 1 is accepted

Sort by
0
Attila Antal
Telerik team
answered on 25 May 2021, 08:20 AM

Hi Itamar,

By default, when Paging is enabled the Grid works with 10 rows at a time, regardless of the number of rows in the data source you bind to it. When you change the page, it will fetch the next 10 rows. This way it never has to treat all data at once.

However, if you prefer the Grid to make a query of a limited number of rows to the database, you can use Custom Paging. This allows you to make a database query for as many rows as you define in the Paging logic.

Regards,
Attila Antal
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Tags
Grid
Asked by
Itamar
Top achievements
Rank 1
Iron
Iron
Answers by
Attila Antal
Telerik team
Share this question
or