110,533
社区成员
发帖
与我相关
我的任务
分享
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=1.mdb; Persist Security Info=True;");
if (conn.State == ConnectionState.Closed)
conn.Open();
for ( int i = 0; i < dt.Rows.Count; i ++)
{
string sql = "insert into 表1(字段1,字段2,字段3,字段4,字段5,字段6,字段7,字段8,字段9,字段10,字段11,字段12) values ('" + dt.Rows[i][0].ToString() + "','" + dt.Rows[i][1].ToString() + "','" + dt.Rows[i][2].ToString() + "','" + dt.Rows[i][3].ToString() + "','" + dt.Rows[i][4].ToString() + "','" + dt.Rows[i][5].ToString() + "','" + dt.Rows[i][6].ToString() + "','" + dt.Rows[i][7].ToString() + "','" + dt.Rows[i][8].ToString() + "','" + dt.Rows[i][9].ToString() + "','" + dt.Rows[i][10].ToString() + "','" + dt.Rows[i][11].ToString() + "')";
OleDbCommand cmd = new OleDbCommand(sql, conn);
cmd.ExecuteNonQuery();
}
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=1.mdb; Persist Security Info=True;");
if (conn.State == ConnectionState.Closed)
conn.Open();
OleDbCommand cmd = new OleDbCommand();
List<string> SQLStringList=new List<string> ();
for (int i = 0; i < dt.Rows.Count; i++)
{
string sql = "insert into 表1(字段1,字段2,字段3,字段4,字段5,字段6,字段7,字段8,字段9,字段10,字段11,字段12) values ('" + dt.Rows[i][0].ToString() + "','" + dt.Rows[i][1].ToString() + "','" + dt.Rows[i][2].ToString() + "','" + dt.Rows[i][3].ToString() + "','" + dt.Rows[i][4].ToString() + "','" + dt.Rows[i][5].ToString() + "','" + dt.Rows[i][6].ToString() + "','" + dt.Rows[i][7].ToString() + "','" + dt.Rows[i][8].ToString() + "','" + dt.Rows[i][9].ToString() + "','" + dt.Rows[i][10].ToString() + "','" + dt.Rows[i][11].ToString() + "')";
SQLStringList.Add (sql );
}
OleDbTransaction trans = conn.BeginTransaction();
for (int n = 0; n < SQLStringList.Count ; n++)
{
string strsql = SQLStringList[n].ToString();
cmd.Connection = conn;
cmd.Transaction = trans ;
cmd.CommandText = strsql;
cmd.ExecuteNonQuery();
}
trans.Commit();