Transactions In ASP

For eg:In a asp page i have 2 insert statements & 1 update statements.All these 3 statements I am executing on same asp page by creating a connection object.But I want to make sure that if first 2 insert statements execute successfully, then only 3rd update is executed.

It is possible that after the execution of first 2 insert statements database goes down and 3 rd update statement does not execute at all.In short I want to treat these 3 statements as a single transaction block and ensure that either all the 3 or none of the statements are executed.

How do I control it in asp page?By writing stored procedures in database & executing it as a single transaction block(using begin transaction & abort or commit) it is possible.But is there a way to conrol this using asp?