How Can I check whether DataReader has Data or not?

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

Dim cmd as SqlCommand
Dim drd as SqlDataReader

      cmd = New SqlCommand ("SELEC开发者_StackOverflowT * 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! Thank in advance!

---

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

---

Yes you can with drd.read()

Like:

If drd.read() Then
    ...do things with data...
Else
    ...show message box... or just skip.
End If

---

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