Record selection method?

6 posts, 0 answers
  1. Hasan
    Hasan avatar
    11 posts
    Member since:
    Dec 2013

    Posted 21 Dec 2013 Link to this post

    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.
  2. Shinu
    Shinu avatar
    17764 posts
    Member since:
    Mar 2007

    Posted 22 Dec 2013 Link to this post

    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.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Hasan
    Hasan avatar
    11 posts
    Member since:
    Dec 2013

    Posted 23 Dec 2013 Link to this post

    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!!!



  5. Daniel
    Admin
    Daniel avatar
    4945 posts

    Posted 26 Dec 2013 Link to this post

    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.
  6. Hasan
    Hasan avatar
    11 posts
    Member since:
    Dec 2013

    Posted 27 Dec 2013 Link to this post

    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?
  7. Daniel
    Admin
    Daniel avatar
    4945 posts

    Posted 31 Dec 2013 Link to this post

    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.
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017