How I can get a "Select Top 100" records

Thread is closed for posting
2 posts, 0 answers
  1. PagosInteligentes
    PagosInteligentes 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="********************, ********************"
            OrderBy="Id DESC">

  2. Zoran
    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,
    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 >>

Back to Top