Check for empty sqldatareader

[Sosh123]

Hi,

Could anybody suggest a way of checking for an empty datareader, without
using Read()?

Thanks

 

[Phillip Ian]

if rdr.HasRows then
...
end if

 

[Guest]

sqldatareader.HasRows

Elton Wang
(e-mail address removed)

 

[William F. Robertson, Jr.]

Why would you not want to use dr.Read()?

bill

 

[Sosh123]

Becuase it would move the row cursor on one. Looks like the HasRows
property is just the ticket though. Thanks.