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

Record selection method?

5 Answers 40 Views
DataPager
This is a migrated thread and some comments may be shown as answers.
Hasan
Top achievements
Rank 1
Hasan asked on 21 Dec 2013, 10:34 AM
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.

5 Answers, 1 is accepted

Sort by
0
Shinu
Top achievements
Rank 2
answered on 23 Dec 2013, 03:02 AM
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.
0
Hasan
Top achievements
Rank 1
answered on 23 Dec 2013, 10:32 AM
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!!!



0
Daniel
Telerik team
answered on 26 Dec 2013, 02:23 PM
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
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
Hasan
Top achievements
Rank 1
answered on 27 Dec 2013, 09:02 PM
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?
0
Daniel
Telerik team
answered on 31 Dec 2013, 03:25 PM
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
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.
Tags
DataPager
Asked by
Hasan
Top achievements
Rank 1
Answers by
Shinu
Top achievements
Rank 2
Hasan
Top achievements
Rank 1
Daniel
Telerik team
Share this question
or