Så kom der lige lidt mere der sku huskes
SQL to remember
private bool BoolExecuteSQL(string SQL_STATEMENT)
{
string SQLCommit = "commit";
OracleConnection dbConnection = new OracleConnection(OracleConnString);
try
{
OracleCommand CreateStm1Command = new OracleCommand(SQL_STATEMENT, dbConnection);
CreateStm1Command.Connection.Open();
CreateStm1Command.ExecuteNonQuery();
ExecuteSQL(SQLCommit);
}
catch (Exception ex)
{
WriteStringToLog("Failed to Execute SQLStatement " + ex.Source.ToString() + " " + ex.Message.ToString() + " Statement: " + SQL_STATEMENT);
MessageBox.Show("Failed to Execute SQLStatement " + ex.Source.ToString() + " " + ex.Message.ToString() + " Statement: " + SQL_STATEMENT);
return false;
}
finally
{
if(dbConnection != null && dbConnection.State == ConnectionState.Open)
dbConnection.Close();
}
return true;
} // BoolExecuteSQL
SQL to remember
private bool BoolExecuteSQL(string SQL_STATEMENT)
{
string SQLCommit = "commit";
OracleConnection dbConnection = new OracleConnection(OracleConnString);
try
{
OracleCommand CreateStm1Command = new OracleCommand(SQL_STATEMENT, dbConnection);
CreateStm1Command.Connection.Open();
CreateStm1Command.ExecuteNonQuery();
ExecuteSQL(SQLCommit);
}
catch (Exception ex)
{
WriteStringToLog("Failed to Execute SQLStatement " + ex.Source.ToString() + " " + ex.Message.ToString() + " Statement: " + SQL_STATEMENT);
MessageBox.Show("Failed to Execute SQLStatement " + ex.Source.ToString() + " " + ex.Message.ToString() + " Statement: " + SQL_STATEMENT);
return false;
}
finally
{
if(dbConnection != null && dbConnection.State == ConnectionState.Open)
dbConnection.Close();
}
return true;
} // BoolExecuteSQL