title: Querying inside a Dataset C#
body: <p>I have an ADO.NET dataset which is set by a certain query,
  say</p>
  
  <pre><code>SELECT ID,USER,PRODUCT,COUNT FROM PRODUCTION
  </code></pre>
  
  <p>Without using a where clause I need to derive some results from the dataset. Say I want to get the User and Product count of the user who has the maximum product count. (And I want to do it by using the existing dataset. I can't derive this from dataset.)</p>
  
  <p>Any idea of a way to query inside the dataset? Since there are Datatables my thought was there is some way to query it. </p>