Dataset top n lines in c #

Question

I want to select the top N rows from a dataset. is there any way to do this in c #? I do not have access to SQL Server stored procedures to modify them, so I only need to show some data binding strings.

how would i do that?

Answer 1

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

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

Answer 2

Using the DataAdapter.Fill method, we can implement paging in sqlserverce 3.0

 string Query = "Select * From WorkOrderDetails order by AssetID ASC"; SqlCeDataAdapter da = new SqlCeDataAdapter(Query, strConString); DataTable dt = new DataTable(); //da.Fill(startIndex, endIndex, dt); da.Fill(startIndex, 100, dt); dataGrid1.DataSource = dt; 

Answer 3

 string Query = "Select * From WorkOrderDetails order by AssetID ASC"; SqlCeDataAdapter da = new SqlCeDataAdapter(Query, strConString); DataTable dt = new DataTable(); //da.Fill(startIndex, endIndex, dt); da.Fill(startIndex, 100, dt); dataGrid1.DataSource = dt;