dataset top n rows in c#

Question

I want to select top N rows from a dataset. is there any way to do it in C# ? i dont have access to sql server stored procedures to change them so I need to show only some rows to data bind.

how would I go about this?

Answer 1

If you are using framework 3.5, then first get the datatable (dt) and then use the below line -

dt.Rows.Cast<System.Data.DataRow>().Take(n)