OLEDb.DataReader

[SQL]

Hi, is there a method to move to the next record in a datareader? Kind of
like the rs.MoveNext from VB6...

Thanks

 

[Armin Zingler]

Hi, is there a method to move to the next record in a datareader?
Kind of like the rs.MoveNext from VB6...

There's an example in the datareader documentation.

See also ADO.Net docs:
http://msdn.microsoft.com/library/en-us/cpguide/html/cpcontheadonetdatareader.asp

Group for ADO.Net related questions:
microsoft.public.dotnet.framework.adonet

--
Armin

How to quote and why:
http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

 

[Cor Ligthert]

Hi SQL

A datareader and a recordset are two different things.

A datareader reads streaming/sequential records from a database and than
they are gone.

A recordset is filled using a datareading process and all records stay to
your disposal as long as you wish.

The most near the recordset comes the dataset.

The main differences between a recordset and a dataset are that a dataset
can hold more recordtables, while a recordset only one and that a dataset
is disconnected while a recordset is connected to the database.

However things like movenext are possible with a dataset as well as a
datareader (reading next). But with a datareader is no move previous, while
that is possible with a dataset and a recordset.

I hope this clears it something?

Cor