Scrolling and retrieving rows similar like ado recordset

[Guest]

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

 

[Val Mazur \(MVP\)]

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.