Partially loading data from oracle db

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Slawekr
Posts: 1
Joined: Fri 21 Apr 2006 14:13

Partially loading data from oracle db

Post by Slawekr » Fri 21 Apr 2006 14:21

Hello,
does OraDirect support partially loading data to user application using OracleDataAdapter and DataSet objects.
User could see initially first page of data, which fits in visible part of data grid, then scrolling down data grid DataAdapter loads further parts of records.

Thanks
S.

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Wed 26 Apr 2006 09:04

Use FillPage(int,int) function (OracleDataTable component) which fills the Rows collection of the OracleDataTable with rows from the data source starting at the row indicated by startRecord and including up to the number of rows indicated by maxRecords.

Post Reply