title: how to set result of aggregate sql query as lable caption
body: <p>I am using this code to retrieve no of machines (count)...</p>
  
  <pre><code>    Dim strCntSr As String = "SELECT count(sr_no) FROM Vendor_Machine WHERE chaln_no='" &amp; cmbChal_no.Text &amp; "'"
      comm_getCnt = New OleDb.OleDbCommand(strCntSr, cnnOLEDB)
      comm_getCnt.ExecuteNonQuery()
  
      ***Here I want to set result of the above query [count(sr_no)] as text of lblMachine***
  
      lblMachine.Text = 
  </code></pre>
  
  <p>Please suggest me the code.. Thank you..</p>