C#: retrieve the first n records from a DataTable

Question

Hi,

I have a DataTable that contains 2000 records.

How would you retrieve the first 100 records in the DataTable?

Answer 1

If it implements IEnumerable<T>:

var first100 = table.Take(100);

If the type in question only implements IEnumerable, you can use the Cast extention method:

var first100 = table.Cast<Foo>().Take(100);

Answer 2

This works for DB2.

select * from table
fetch first 100 rows only;

Answer 3

and for mysql: select * from table limit 100

Answer 4

You could use something like this, but restrict the foreach loop to 100 records.

Answer 5

And to make the list full, here is the statement for MS SQL:

Select top 5 * from MyTable2

And some other methods with MS SQL can be found here.

Answer 6

To get a list of the top n records in C# using the 2.0 framework:

DataTable dt = new DataTable();
var myRows = new List<DataRow>();

//no sorting specified; take straight from the top.
for (int i = 0; i < 100; i++)
{
   myRows.Add(dt.Rows[i]);
}