title: get single value from sql-query into a textbox
body: <p>The result of my sql-query is a single value i want display that in a lable but dont know how. I have a solution creating a dataset put the result of the query into that dataset and get it by row(0),column(0) but i guess there is a smarter way doing it.</p>
  
  <pre><code>Private myquery As String
  
  Sub New(ByVal query As String)
      myquery = query
  End Sub
  Public Sub query_Send()
      Dim myconn As New SqlConnection("Data Source=DB;Integrated Security=TRUE")
      Dim mycmd As SqlCommand = New SqlCommand(Me.myQuery, myconn)
      Dim myTable As New DataTable
      Dim previousConnectionState As ConnectionState = myconn.State
      Try
          If myconn.State = ConnectionState.Closed Then
              myconn.Open()
              Dim myDA As New SqlDataAdapter(mycmd)
              myDA.Fill(myTable)
              tb.text = **...**
          End If
          If previousConnectionState = ConnectionState.Closed Then
              myconn.Close()
          End If
      End Try
  End Sub
  </code></pre>