初学,写的很苯
string SQL="";
string SQL1="";
OleDbConnection SqlConn = new OleDbConnection(DBConStr);
OleDbCommand cmd = new OleDbCommand();
OleDbCommand cmd1 = new OleDbCommand(); cmd.CommandType = CommandType.Text;
cmd.Connection = SqlConn;
cmd.CommandText = SQL;
cmd1.CommandType = CommandType.Text;
cmd1.Connection = SqlConn;
cmd1.CommandText = SQL1; SqlConn.Open();
cmd.ExecuteNonQuery();
cmd1.ExecuteNonQuery();
SqlConn.Close();
string SQL="";
string SQL1="";
OleDbConnection SqlConn = new OleDbConnection(DBConStr);
OleDbCommand cmd = new OleDbCommand();
OleDbCommand cmd1 = new OleDbCommand(); cmd.CommandType = CommandType.Text;
cmd.Connection = SqlConn;
cmd.CommandText = SQL;
cmd1.CommandType = CommandType.Text;
cmd1.Connection = SqlConn;
cmd1.CommandText = SQL1; SqlConn.Open();
cmd.ExecuteNonQuery();
cmd1.ExecuteNonQuery();
SqlConn.Close();
怎么又用OleDbConnection?
string SQL1= "";
OleDbConnection SqlConn = new OleDbConnection(DBConStr);
OleDbCommand cmd = new OleDbCommand();
cmd.CommandType = CommandType.Text;
cmd.Connection = SqlConn;
//把两个sql语句直接合并一起执行,注意要用空格隔开
cmd.CommandText = SQL+ " "+ SQL1;
SqlConn.Open();
cmd.ExecuteNonQuery();
cmd1.ExecuteNonQuery();
SqlConn.Close();
string SQL1= "";
OleDbConnection SqlConn = new OleDbConnection(DBConStr);
OleDbCommand cmd = new OleDbCommand();
cmd.CommandType = CommandType.Text;
cmd.Connection = SqlConn;
//把两个sql语句直接合并一起执行,注意要用;隔开
cmd.CommandText = SQL+ " ; "+ SQL1;
SqlConn.Open();
cmd.ExecuteNonQuery();
SqlConn.Close();
你用2个Command的话如果第一个执行完了,第二个执行出错你怎么办?还是改用OleDbTransaction来做吧
string SQL1="";
OleDbConnection SqlConn = new OleDbConnection(DBConStr);
OleDbConnection SqlConn1 = new OleDbConnection(DBConStr); OleDbCommand cmd = new OleDbCommand();
OleDbCommand cmd1 = new OleDbCommand(); cmd.CommandType = CommandType.Text;
cmd.Connection = SqlConn;
cmd.CommandText = SQL;
cmd1.CommandType = CommandType.Text;
cmd1.Connection = SqlConn1;
cmd1.CommandText = SQL1; SqlConn.Open();
cmd.ExecuteNonQuery();
SqlConn.Close(); SqlConn1.Open();
cmd1.ExecuteNonQuery();
SqlConn1.Close();