如何一次执行两条SQL语句?
极品司机 2003-05-19 03:08:25 如何一次执行两条SQL语句?
数据库为Oracle9.2.0
//////////////////////////////////////////////////////////////////////////////////////////////////////////////
//建立连接
string ConnectionString = "Provider=MSDAORA.1;Password=forrest;User ID=forrest;Data Source=oratest";
OleDbConnection myConnection = new OleDbConnection(ConnectionString);
myConnection.Open();
//生成SQL语句
string strCreateUser = "CREATE USER " + txtUserName.Text.Trim() + " IDENTIFIED BY " + txtPassword.Text.Trim();
string strGrantRoles = "GRANT connect, resource TO " + txtUserName.Text.Trim().ToUpper();
////如下,分别执行两条语句是没有错误的
// OleDbCommand cmdCreateUser = new OleDbCommand(strCreateUser, myConnection);
// OleDbCommand cmdGrantRoles = new OleDbCommand(strGrantRoles, myConnection);
// cmdCreateUser.ExecuteNonQuery();
// cmdGrantRoles.ExecuteNonQuery();
//如下,将两条SQL语句以分号连接后,则不能成功执行
string strCreateUserGrantRoles = strCreateUser + " ; " + strGrantRoles;
OleDbCommand cmdCreateUserGrantRoles = new OleDbCommand(strCreateUserGrantRoles, yConnection);
cmdCreateUserGrantRoles.ExecuteNonQuery();
//关闭连接
myConnection.Close();
//////////////////////////////////////////////////////////////////////////////////////////////////////////////
在一次执行多条SQL语句的情况下是不是应使用存储过程?
在此例中存储过程应如何书写?
盼请高手指点。