Database

OdbcCommand command = new OdbcCommand();<br />
        OdbcTransaction transaction = null;<br />
<br />
        // Set the Connection to the new OdbcConnection.<br />
        command.Connection = connection;<br />
<br />
        // Open the connection and execute the transaction.<br />
        try<br />
        {<br />
            connection.Open();<br />
<br />
            // Start a local transaction<br />
            transaction = connection.BeginTransaction();<br />
<br />
            // Assign transaction object for a pending local transaction.<br />
            command.Connection = connection;<br />
            command.Transaction = transaction;<br />
<br />
            // Execute the commands.<br />
            command.CommandText =<br />
                "Insert into Region (RegionID, RegionDescription) VALUES (100, 'Description')";<br />
            command.ExecuteNonQuery();<br />
            command.CommandText =<br />
                "Insert into Region (RegionID, RegionDescription) VALUES (101, 'Description')";<br />
            command.ExecuteNonQuery();<br />
<br />
        }<br />
        catch (Exception ex)<br />
        {<br />
            Console.WriteLine(ex.Message);<br />
            try<br />
            {<br />
                <big>// Attempt to roll back the transaction.<br />
                transaction.Rollback();</big><br />
            }<br />
            catch<br />
            {<br />
                // Do nothing here; transaction is not active.<br />
            }<br />
        }