title: Get Count of DataSet.Tables rows based on criteria
body: <p>The code below is returning a value of 0 every time. I am trying to filter a datatable and get the number of rows. To illustrate the example here, I am setting the criteria as the value 250 to be looked for in my ID column in Table2.</p>
  
  <p>How can I fix it?</p>
  
  <pre><code>var count = (from row in MyDatabaseDataSet.Tables["Table2"].AsEnumerable() where string.Equals(row["ID"].ToString(), 250)) select row).Count();
  MessageBox.Show(Convert.ToString(count));
  </code></pre>