Checking if SqlDataReader contains data

[relaxory]

If I'm doing a select WHERE' searching for a string... What is the best
way to condition a response based on whether the datareader contains
data or not?

while (myReader.Read()) {
if myReader.GetInt32(0) = 0

..

Something like that? Isn't there something that can return a bool?

Cheers

 

[Vadym Stetsyak]

if the query returned smth myReader.Read() will be equal to true.

if you always obtain some result, but want to check specific column you can
check it like
if ( reader["myColumnName"] == null )
{}

 

[relaxory]

Superb! Thanks.. I guess I should have looked up .SqlDataReader.Read
Method before I post.

Thanks again.

 

[Miha Markic [MVP C#]]

Hi,

Besides Read() there is also HasRows property.