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.
精彩评论