c# - 将数据表（多行）添加到 ms-access 一次，无需循环 C#

Question

我有一个table包含多条记录的数据表。我想在不使用循环的情况下将此数据表插入 ms-access 表。

我想将多行/记录插入到整个 ms-access 数据库中。我不想一一插入记录。

using (var conn = new OleDbConnection(DatabaseObjects.ConnectionString))
{
      var adap = new OleDbDataAdapter();
      adap.SelectCommand = new OleDbCommand ("select RollNo, SName, FName, DOB, [Section] from students", conn);
      var cb = new OleDbCommandBuilder(adap);
      cb.GetInsertCommand();
      cb.GetDeleteCommand();
      cb.GetUpdateCommand();
      conn.Open();
      adap.Update(table);   
 }

将数据从 Excel 工作表加载到数据表。代码如下，

using (OleDbConnection connExcel = new OleDbConnection(DatabaseObjects.ConnectionStringExcel))
        {
            string queryExcel = "select * from [" + sheetName + "$]";
            using (OleDbCommand commandExcel = new OleDbCommand(queryExcel, connExcel))
            {
                connExcel.Open();
                OleDbDataAdapter adapter = new OleDbDataAdapter();
                adapter.SelectCommand = commandExcel;
                adapter.Fill(dtSheetData);
            }
        }

标签： c#databasems-accessdatatableoledbdataadapter