我再次遇到检查 DataReader 对象是否有数据的问题？

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")
     }

我该如何检查？请帮我!提前致谢!

最佳答案

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

https://stackoverflow.com/questions/1812254/