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

How I can get a "Select Top 100" records

1 Answer 78 Views
Development (API, general questions)
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
PagosInteligentes
Top achievements
Rank 2
PagosInteligentes asked on 30 Sep 2011, 05:59 AM
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

1 Answer, 1 is accepted

Sort by
0
Zoran
Telerik team
answered on 04 Oct 2011, 03:46 PM
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 >>

Tags
Development (API, general questions)
Asked by
PagosInteligentes
Top achievements
Rank 2
Answers by
Zoran
Telerik team
Share this question
or