title: Querying datatable to get rows with a certain value in the first column
body: <p>I am currently using the code below and am wondering if it would be possible to query based on an entry value. At the moment it returns the number of rows that have been defined.  </p>
  
  <pre><code>var q = sqlData.AsEnumerable().Take(2);
  </code></pre>
  
  <p>This data comes in from a database and is imputed into the table but at the moment it only returns database data into the datatable and allows me to select the first two rows and I was wondering if I can query the data table so that I can get the rows that I require based on an index in the actual table itself (e.g. in the table I find five rows and query this information out).</p>