How Can I check whether DataReader has Data or not?

Question

Hi All, Again I have problem with checking whether DataReader object has data or not?

Dim cmd as SqlCommand
Dim drd as SqlDataReader

      cmd = New SqlCommand ("SELECT * FROM Stock", conx)
      drd = cmd.ExecuteReader()

      ''HERE I WOULD LIKE TO CHECK WHETHER drd has Data or not

     While (drd.Read())
     {
          txtName.Text = drd.Item("StockName")
     }

How can I check that? Please Help me! Thanks all in advcance!

Answer 1

if(drd.HasRows)
{
   //....
}

Answer 2

drd.Read() will return False when there is no data. You don't have to change your code.