Binding Large dataSet to radgrid

[Itamar]

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.

 

[Attila Antal]

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