17,086
社区成员
发帖
与我相关
我的任务
分享
using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required))
{
string str = "Insert into test1 (AA,BB,CC,DD) values(:AA,:BB,:CC,:DD)";
OracleConnection OraConn = new OracleConnection (m_dataConnection);
try
{
OraConn.Open();
OracleCommand OraCom = new OracleCommand(str, OraConn);
OraCom.Parameters.Add("AA", OracleDbType.Varchar2 ,part.AA, System.Data.ParameterDirection.Input);
OraCom.Parameters.Add("BB", OracleDbType.Varchar2, part.BB, System.Data.ParameterDirection.Input);
OraCom.Parameters.Add("CC", OracleDbType.Varchar2, part.CC, System.Data.ParameterDirection.Input);
OraCom.Parameters.Add("DD", OracleDbType.Varchar2, part.DD, System.Data.ParameterDirection.Input);
int i = OraCom.ExecuteNonQuery();
if (i == 0)
{
return false;
}
else
{
return true;
}
}
catch(Exception ex)
{
return false;
}
finally
{
if (OraConn.State == System.Data.ConnectionState.Open)
{
OraConn.Close();
}
}
}