title: Display SQL query result in a label in asp.net
body: <p>I'm trying to display the SQL query result in a label but it's not showing. This is my code:</p>
  
  <pre><code>     string result = "SELECT ACTIVE FROM [dbo].[test] WHERE ID = '" + ID.Text + "' ";
       SqlCommand showresult = new SqlCommand(result, conn);
       conn.Open();
       showresult.ExecuteNonQuery();
       string actresult = ((string)showresult.ExecuteScalar());
       ResultLabel.Text = actresult;
       conn.Close();
  </code></pre>
  
  <p>Need help please. Thanks!</p>