title: Select top N rows AFTER sorting from Dataview in c#
body: <p>I have a DataTable with 10 rows say one of the columns
  numbered 1 to 10 randomly. 
  I want to sort them. usually, I do this:</p>
  
  <pre><code>DataView Dv = new DataView(dtPost, "", "views desc", DataViewRowState.Unchanged);
  repeater.DataSource = Dv;
  repeater.DataBind();
  </code></pre>
  
  <p>Now, I just want to bind the top 5 rows in this Dataview. If I try this:</p>
  
  <pre><code>DvPopBlogs.Table.Rows.Cast&lt;System.Data.DataRow&gt;().Take(5);
  
  OR
  
  DvPopBlogs.Table.AsEnumerable().Take(5); //this usually works if sorting wasnt necessary
  </code></pre>
  
  <p>It works, but the dataView completely forgets about the sorting and just selects 5 rows from top.</p>
  
  <p>I have tried it with all DataViewRowStates too. How to select top 5 rows after sorting?</p>
  
  <p>I seem to run out of ideas!
  please help!</p>