我想在一个方法是执行多个SQL语句我这样写可以吗?
public static void fuquan()
{
OracleConnection conn = new OracleConnection("Data Source=txun;User ID=zhang;Password=o123;Integrated Security=no");
conn.Open();
OracleCommand cmd1 = new OracleCommand("GRANT CREATE SESSION to " + dataconn.uname, conn);
cmd1.ExecuteNonQuery(); OracleCommand cmd2 = new OracleCommand("GRANT ALTER ANY TABLE TO" + dataconn.uname, conn);
cmd2.ExecuteNonQuery();
conn.Close();
}
public static void fuquan()
{
OracleConnection conn = new OracleConnection("Data Source=txun;User ID=zhang;Password=o123;Integrated Security=no");
conn.Open();
OracleCommand cmd1 = new OracleCommand("GRANT CREATE SESSION to " + dataconn.uname, conn);
cmd1.ExecuteNonQuery(); OracleCommand cmd2 = new OracleCommand("GRANT ALTER ANY TABLE TO" + dataconn.uname, conn);
cmd2.ExecuteNonQuery();
conn.Close();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货