records affected

[simon]

I have datareader. I filled it with data and also if I use rdr.has rows it
returns True.

If I use rdr.read and scroll over it, it works.

But if I wants to finds the records affected I always get -1.

rdr.RecordsAffected=-1

Why?

Regards,
Simon

 

[Guest]

Quote from .NET Documentation
"The number of rows changed, inserted, or deleted; 0 if no rows were
affected or the statement failed; and -1 for SELECT statements."

I believe that DataReader does not return recordcount because it provides
forward-only reading through result set.

 

[Mark Rae]

Quote from .NET Documentation
"The number of rows changed, inserted, or deleted; 0 if no rows were
affected or the statement failed; and -1 for SELECT statements."

I believe that DataReader does not return recordcount because it provides
forward-only reading through result set.

Correct. The DataReader has no notion of the number of records it contains -
only that it does or does not contain any records.