HasRows property

[Stijn Verrept]

I am having the same problem as the person in this thread mentions:
http://groups.google.be/groups?q=asp+net+empty+datareader+hasrows&hl=nl&
lr=&ie=UTF-8&oe=UTF-8&selm=u2ct0sgzCHA.640%40TK2MSFTNGP12&rnum=1

Somebody says that framework 1.1 will have a HasRows property but this
doesn't seem true. Is there such a property and if not is there a good
solution yet?

 

[stefano mostarda]

The property exists. It is included in the datareader object.

Best Regards.
Stefano Mostarda
Rome Italy

 

[Teemu Keiski]

Yes, there is such property but as was said in the reply, it addresses the
problem but doesn't remove it e.g you still need to do the check,.

You could have a check like this:

If sqlDataReader.HasRows Then
DataGrid1.DataSource = sqlDataReader
DataGrid1.DataBind()
Else
Label1.Text = "No records found"
End If