title: ASP.NET SQL Query look for MAX Value
body: <p>I would like to fire an SQL Query from my ASP.NET page (vb), what the query will do is to look for the maximum value from a column and then return that value and place it into a label in the webpage.</p>
  
  <p>Currently i dont know to fire the SQL command and then return with the value, a correction to my code is hihgly appreciated.</p>
  
  <pre><code>Dim Con As New SqlConnection
          Dim SQL As String
          Con.ConnectionString = "Data Source=WCRDUSMJEMPR9\SQLEXPRESS;Initial Catalog=MicroDB;Integrated Security=True"
          Con.Open()
          SQL = "SELECT MAX(ID_ControlCharts) FROM ControlCharts"
          Label123.Text = SQL
  </code></pre>
  
  <p>The code above is not working, i know that i need to execute the query however i'm totally lost.</p>