Hi there!
I have 10 ASP pages, (all use the same database-but each page using a different table in the database). After going through all the 10 pages, the user is redirected to a page, which contains 'Commit' and 'Cancel' butttons. If the user clicks the Commit button, all the information enetered in those forms needs to be committed. On the other hand if he chooses the Cancel button, all the information entered should be rollbacked.
So I used the MTS. In the very first page, I have used <%@transaction=requires_New %> and in all other pages, I have given <%@transaction=Supported %>. In the 11th page, if the user clicks the 'Cancel' button, I am calling the ObjectContext.SetAbort method. If the user clicks the 'Commit' button, I am calling the ObjectContext.SetComplete method.
I thought this will work fine. But to my surprise, what the MTS is doing is it calls the SetAbort/SetComplete methods of ObjectContext at the end of the everypage.
I am using a SQL-Server database. What should I do to get the desired result? Please, please help me.

Thanx in Advance.