title: how to store sql query results in a variable in c#
body: <p>query i am using </p>
  
  <p>string query = "select rescod from tbres,tbmnu where rescod = mnures and mnucod =1";</p>
  
  <p>result from this query is 5</p>
  
  <p>i would like to store the result of this query in an integer variable RESULT</p>