connection.Open();
OleDbCommand command = new OleDbCommand();
command.Connection = connection;
string querytransactions = "select TransactionID as 'الرقم المرجعي' , TransactionDate as 'تاريخ العملية' , TransactionDescription as 'وصف العملية' , AccountID as ' الحساب' , WithdrawalAmount as ' مسحوبات' , DepositAmount as ' ايرادات' from transactions";
command.CommandText = querytransactions;
command.ExecuteNonQuery();
OleDbDataAdapter da = new OleDbDataAdapter(command);
DataTable dttransactions = new DataTable();
da.Fill(dttransactions);
dataGridView3.DataSource = dttransactions;
DataSet ds = new DataSet() ;
ds.Clear();
da.Fill(ds, scr_val, 5);
connection.Close();
我只想从DataGridView中的该查询中显示5个记录,我正在使用访问数据库,然后分页获取下一个5直到结束我不需要从交易中选择top 5,并且访问db dy没有限制查询,所以我可以做什么
您可以使用linq跳过记录,并从数据集的结果数据台上获取下一组数据。您将通过跳过计数,并从前端进行计数。不是最有效的查询,而是考虑到您可以按照:
进行操作的有限上下文。ds.Tables[0].Select().Skip(5).Take(5); // skips 5 rows, then selects five after that.