can transaction be rolled back after its commited and connection is closed

Question

        finally
        {
            // Commit the transaction.
            sqlTran.Commit();

            reader.Close();
            reader.Dispose();

            conn.Close();
            conn.Dispose();            
        }

i would like to give the user an option of opps! roll it back so its commited can it be rolled back?

Answer 1

commited transaction can never be rolled back, while you want your transaction to be persistent after a commit.

Are you looking for savepoints?

Answer 2

Well if it committed, it is committed. No rolling back. If you want to be dumb-user-proof, set up a timer and commit only after a delay, giving the user the option to rollback for a while.

Answer 3

simply no. you cannot :)

The Commit method is equivalent to the Transact-SQL COMMIT TRANSACTION statement. You cannot roll back a transaction once it has been committed, because all modifications have become a permanent part of the database.

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqltransaction.commit.aspx

Answer 4

If you put your 'oops!' case at the appropriate point you should be able to do what you need.

Also, take a look at nested transactions, maybe that'll fit your scenario even better.

Finally as Tobias points out there are save points.