title: DataTable.Select retrieving all rows?
body: <p>I have this code:</p>
  
  <pre><code>allGyms.Select("type = 1");
  foreach(DataRow allGymsRow in allGyms.Rows)
  {
  
  }
  </code></pre>
  
  <p>The allGyms stored 25 rows, 7 rows with a type of 1 and another 7 with a type of 2 and so on.. Now I'm trying to use the current <code>DataTable</code> to retrieve the rows with a type of 1, so it should return 7 rows.. However when I debug into the foreach loop, the allGyms has 25 rows rather than the expected 7..</p>
  
  <p>Does anyone know what I am doing wrong? </p>