Scrolling and retrieving rows similar like ado recordset

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hari - 29 Apr 2005 19:52 GMT

Hi,

I working on implementing a scrolling and record navigation with ADO.NET. In
ado recordset having builtin caching/paging and record navigation methods.
but i could find a similar conecpts in ADO.NET classes.. Am i missing
something?? In dataset class i cannot set pagesize/cachesize, so if i execute
a query with a large resultsets with dataset all the rows loaded in the
memory. so iam not getting any cursor navigation conecpt benefits in ado.net
classes???

Hari

Reply to this Message

Val Mazur \(MVP\) - 30 Apr 2005 02:29 GMT

Hi,

ADO.NET DataSet works similar (but not exactly) to client-side disconnected
ADO recordset. DataSet and DataTable are always in a disconnected mode. The
only cursor available in .NET is Read-only forward-only which could be
opened using DataReader. To avoid any performance issues it is not suggested
to load DataSet with the huge amount of data at one time.

Signature

Val Mazur
Microsoft MVP

http://xport.mvps.org

> Hi,
>
[quoted text clipped - 10 lines]
>
> Hari

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...