OLEDb.DataReader

  • Thread starter Thread starter SQL
  • Start date Start date
S

SQL

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

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