Scrolling and retrieving rows similar like ado recordset

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top