Notifies that a transaction has begun and that all modifications to the database are only committed after a call to Commit. Alternatively, if Rollback is called then all changes are aborted. To execute other statements for the transaction call the Execute and ExecuteNonQuery functions. Because all changes to the database must be executed on the same connection DatabaseObjects maintains an open connection until the Commit or Rollback functions are called. When transactions are not being used connections are opened and closed for each SQL statement executed i.e. (INSERT/UPDATE/SELECT...).

Notifies that a transaction has begun and that all modifications to the database are only committed after a call to Commit. Alternatively, if Rollback is called then all changes are aborted. To execute other statements for the transaction call the Execute and ExecuteNonQuery functions. Because all changes to the database must be executed on the same connection DatabaseObjects maintains an open connection until the Commit or Rollback functions are called. When transactions are not being used connections are opened and closed for each SQL statement executed i.e. (INSERT/UPDATE/SELECT...).