RollBack in C#.Net

[try.test.abc]

Hi
I am working on the application where i have to execute multiple transaction like update, select and insert one by one. If one of them fail, i want to rollback whole the transaction. and this transaction depends on one another.
So dont know how to use rollback.

In my application, First I am Updating table1, and then fetch some value from that and use that to insert into another table. But the transaction will not be saved untill commit appear. and so cant execute the next statement.

[klintan]

You can use either ADO .Net transaction or System.Transactions. Look at MSDN for examples.