Moving more than one record in datareader

[Niraj Ranka]

Hello,

Can we move more than one record in datareader ... or saying it can we
directly move to say 10th record in the datareader instead of going from 1
to 10th record using datareader.read() method.


Please review...

Niraj Ranka

 

[Patrice]

AFAIK no, the reader is a sequential read only forward only stream. If you
want to ignore lines you could just avoid to include them in the result set
by changing your selection criteria.

Patrice

 

[W.G. Ryan eMVP]

No - nor would you want to. If you need this functionality use a
DataTable/DataSet.