title: SQL datareader into int
body: <p>I am simply trying to use a datareader to read the integer at datareader[0] into an integer called "price per night".</p>
  
  <pre><code>int price_per_night = 0;
  while (read_price.Read())
  {
      price_per_night = (read_price[0]);
  }
  </code></pre>
  
  <p>No matter how many approaches I try it will not convert. Is there a definitive answer?</p>