title: How to sort dataset.table[0] then get the top 10?
body: <p>I'm adding an auto increment column (called "rowNum") to my table and it's working good, after that I use this code to sort datatable rows :</p>
  
  <pre><code>DataView dv = MyDataSet.Tables[0].DefaultView;
  dv.Sort = "columnName DESC";
  </code></pre>
  
  <p>where columnName is one of my columns (not the auto increment one).</p>
  
  <p>Now,The problem is:
  when I want to get the top 10 rows I use this code :</p>
  
  <pre><code>dv.RowFilter = "rowNum &lt;= 10";
  </code></pre>
  
  <p>The result is not what I want, because when I do <code>dv.Sort</code> the rowNum shuffled (becomes in wrong order).  </p>
  
  <p>How can I get top 10 rows after sorting rows?</p>