Record selection method?

[Hasan]

hi , i'm new in asp.net and also using telerik.my question is when use datapager in form with other control such as : asp:SqlDataSource and select command like SELECT * FROM [Table] , all record get from table or this control chunk selected record from table.
Thanks.

[Shinu]

Hi Hasan,

The Select query will returns all the columns from all rows in the table. The number of data displayed in one page is based on the PageSize of the RadDataPager. Please have a look into this help documentation and this forum thread.

Thanks,
Shinu.

[Hasan]

Hi Shinu,
thank for your answer but i think my Question asked bad!!
look i know SELECT * FROM [Table] get all the columns from all rows in the table.
What I want to know is that for each page that RadDataPager shown based on PageSize all record get from table and put this to memory and when page change all record grab again from table or record get as PageSize for each page.
thanks and sorry if my text is written wrong My English is poor!!!

[Daniel]

Hello Hasan,

I'm not sure that I fully understand your question, but I suppose that you would like to cache the datasource. If this is so, can you please provide some more information about your scenario? What control is paged with RadDataPager in this case?

Regards,
Daniel
Telerik

[Hasan]

Hi Daniel
It is very easy.look at this Demo and tell me when in default Page size: 6 and its in page 1, all 77 Record now get from table and it's placed in memory or only 6 record that shown at this moment get from table?

[Daniel]

Hello Hasan,

If the datasource control supports paging natively (LinqToSql, EntityDataSource, etc) you will get only the current records. This would not be the case when binding to SqlDataSource for example.

Regards,
Daniel
Telerik