How to select top n rows from a datatable/dataview in ASP.NET

Question

How to the select top n rows from a datatable/dataview in ASP.NET? Currently I am using the following code, passing the table and number of rows to get the records. Is there a better way?

public DataTable  SelectTopDataRow(DataTable dt, int count) {      DataTable dtn = dt.Clone();      for (int i = 0; i < count; i++)      {          dtn.ImportRow(dt.Rows[i]);      }       return dtn; } 

Answer 1

In framework 3.5, dt.Rows.Cast<System.Data.DataRow>().Take(n)

Otherwise the way you mentioned

Answer 2

I just used Midhat's answer but appended CopyToDataTable() on the end.

The code below is an extension to the answer that I used to quickly enable some paging.

int pageNum = 1; int pageSize = 25;  DataTable dtPage = dt.Rows.Cast<System.Data.DataRow>().Skip((pageNum - 1) * pageSize).Take(pageSize).CopyToDataTable();