数据集c中的前n行#

如果您使用的是framework 3.5, 然后首先获取datatable(dt),然后使用下面的行-

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

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;

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;