How I can get a "Select Top 100" records

2 posts, 0 answers
  1. Juan Daniel Caicedo Ardila
    Juan Daniel Caicedo Ardila avatar
    8 posts
    Member since:
    May 2010

    Posted 30 Sep 2011 Link to this post

    How I can get a "Select Top 100" records using a OpenAccessDataSource?

    I can see the Order property and Where Property but I cant see how I can set the number of records to return.

        <telerik:OpenAccessDataSource ID="MonitorODS" runat="server"
            ObjectContextProvider="********************, ********************"
            TypeName="********************"
            OrderBy="Id DESC">
        </telerik:OpenAccessDataSource>

    Thanks
  2. Zoran
    Admin
    Zoran avatar
    534 posts

    Posted 04 Oct 2011 Link to this post

    Hi Juan Daniel Caicedo Ardila,

     This is a parameter that is passed to the datasource by the UI control that you have bound it to. For example if you bind it to a grid and set the paging parameters on the grid to select 100 records per page, the datasource will take those parameters in account and perform paging on the database server.

    All the best,
    Zoran
    the Telerik team

    Thank you for being the most amazing .NET community! Your unfailing support is what helps us charge forward! We'd appreciate your vote for Telerik in this year's SQL Server Community Awards. We are competing in TWO categories and every vote counts! VOTE for Telerik NOW >>

  3. DevCraft banner
Back to Top