//实现数据库事务
public static
void ExecuteSqlTran(string SQLString1, string
SQLString2)
{
using
(OracleConnection conn = new
OracleConnection(_DBConnectionString))
{
conn.Open();
OracleCommand cmd = new
OracleCommand();
cmd.Connection =
conn;
OracleTransaction tx =
conn.BeginTransaction();
cmd.Transaction =
tx;
try
{
cmd.CommandText =
SQLString1;
cmd.ExecuteNonQuery();
cmd.CommandText =
SQLString2;
cmd.ExecuteNonQuery();
tx.Commit();
}
catch (System.Data.OracleClient.OracleException
E)
{
tx.Rollback();
throw new
Exception(E.Message);
}
}
}