C #: get first n records from DataTable

Question

I have a DataTablecontaining 2000 entries.

How would you extract the first 100 entries in DataTable?

Answer 1

If it implements IEnumerable<T>:

var first100 = table.Take(100);

If the type in question implements only 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

mysql: select * from table limit 100

Answer 4

- this, foreach 100 .

Answer 5

, MS SQL:

Select top 5 * from MyTable2

MS SQL .

Answer 6

n # 2.0:

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]);
}