private void ExecuteSQL(string SQL_STATEMENT)
{
System.Data.OracleClient.OracleConnection dbConnection = new OracleConnection(OracleConnString);
try
{
OracleCommand CreateStm1Command = new OracleCommand(SQL_STATEMENT, dbConnection);
CreateStm1Command.Connection.Open();
CreateStm1Command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("Failed to Execute SQLStatement " + ex.Source.ToString() + " " + ex.Message.ToString() + " Statement: " + SQL_STATEMENT);
}
finally
{
if(dbConnection != null && dbConnection.State == ConnectionState.Open)
dbConnection.Close();
}
}
{
System.Data.OracleClient.OracleConnection dbConnection = new OracleConnection(OracleConnString);
try
{
OracleCommand CreateStm1Command = new OracleCommand(SQL_STATEMENT, dbConnection);
CreateStm1Command.Connection.Open();
CreateStm1Command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("Failed to Execute SQLStatement " + ex.Source.ToString() + " " + ex.Message.ToString() + " Statement: " + SQL_STATEMENT);
}
finally
{
if(dbConnection != null && dbConnection.State == ConnectionState.Open)
dbConnection.Close();
}
}