title: How to retrieve the count of the number of rows in asp.net mvc from sql database?
body: <p>I am trying to print something if the number of rows returned is more than 0 based on a query:</p>
  
  <pre><code>using (SqlConnection con = new SqlConnection("ConnectionString")){
    con.Open();
    string query = "SELECT COUNT(*) FROM Some_Table WHERE Val &gt; 5";
    SqlCommand cmd = new SqlCommand(query, con);
    cmd.ExecuteNonQuery(); // get the value of the count
    if (count &gt; 0) 
    {
      Console.WriteLine("Returned more than 0 rows");
    }
    else
    {
      Console.WriteLine("Did not return more than 0 rows");
    }
    Console.ReadLine();
  }
  </code></pre>
  
  <p>How can I find the number of rows returned?</p>