Using transactions in ASP.NET is quite similar to using them in classic ASP.
The only real difference is that you now employ the use of a Transaction object
instead of calling methods of the Connection object to start and end a transaction.
Due to the extra object, the code can get a bit confusing so hopefully this sample will
help clear things up some.