title: Execute Scalar to trap error in case of no records returned
body: <p>I have got this code below:</p>
  
  <pre><code>Dim lJobName As String = ""
  SQLCommand.CommandText = "Select JobName from Jobs where Id = @Id "
  SQLCommand.Parameters.Add(New SqlParameter("@Id", SqlDbType.Int))
  SQLCommand.Parameters(0).Value = var_id
  lJobName = SQLCommand.ExecuteScalar()
  </code></pre>
  
  <p>Issue how to catch if no records are found?</p>