How Can I check whether DataReader has Data or not?

Question

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! Thank in advance!

Accepted Answer

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

How Can I check whether DataReader has Data or not?

Solution

Problem