经过多次的测试,最终写出了access数据库一次插入多条数据

OleDbConnection inconn = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=DB.mdb");
inconn.Open();
OleDbTransaction myTrans = inconn.BeginTransaction();
OleDbCommand incmd = inconn.CreateCommand();
incmd.Transaction = myTrans;
string time = "软件";
string sqlstr = "insert into Faultlibrarytable (EquipmentTableID,FaultNumber,LineOn,EquipmentName) Values({0},{1},'{2}','{3}')";
for (int i = 0; i < 32; i++)
{
incmd.CommandText = string.Format(sqlstr,i, i, time, time);
incmd.ExecuteNonQuery();
}
myTrans.Commit();

原文地址:https://www.cnblogs.com/FLWL/p/3900791.html