What are the steps involved in using a transaction object in ADO.NET?-tech17032012

1.Open a database connection. 2.Create the transaction object using the database connection object’s BeginTransaction method. 3.Create command objects to track with this transaction, assigning the Transaction property of each command object to the name of the transaction object created in step 2. 4.Execute the commands. Because the purpose of transaction processing is to detect and correct errors before data is written to the database, this is usually done as part of an error-handling structure. 5.Commit the changes to the database or restore the database state, depending on the success of the commands. Close the database connection.