c# 数据库插入数据

2019独角兽企业重金招聘Python工程师标准>>>

oleDbConn = new OleDbConnection("数据库连接字符串");
oleDbConn.Open();            
OleDbCommand cmd = new OleDbCommand("insert into 表1(col1,col2) values (@col1,@col2)", oleDbConn);
cmd.Transaction=oleDbConn.BeginTransaction();
cmd.Parameters.AddWithValue("@col1", "参数1");
cmd.Parameters.AddWithValue("@col2", "参数2");
cmd.ExecuteNonQuery();
cmd.Transaction.Commit();
oleDbConn.Close();

转载于:https://my.oschina.net/jingshishengxu/blog/510042