Data table select top 5 rows

Question

Hi is there any way to select top 5 rows from a data table without iteration?

Answer 1

why not adapt the underlaying select you are building your dataTable/dataSet with? otherwise give google a try :)

everything else would be an iteration...

Answer 2

If you use a LINQ statement, you could use the Take() method.

This post may be of some assistance as well.

EDIT

As you are using VS2005, use the SELECT() method in the datatable like so:

DataRow[] rows = datatable.Select('TOP 5');

Answer 3

I think, You can use LINQ:

datatable.AsEnumerable().Take(5);