How Do I Rollback Operation If First Two Transaction Occurs Successfully But Third Transaction Cannot Be Successful

See more:

C#

ASP.NET

T-SQL

I am developing .net application where in three operations are to be performed at one go. At first, record is to be inserted into table, then first mail is to be send to admin and second mail is to be send to user who fills form.. I am not sure as to how can these three operations can be performed successfully. If first two operations are completed and last operation is not able to complete, then it must rollback. I am thinking of using transaction to do so and roll back using try catch exception if any of the operation is not complete. But my doubt is if record is inserted and first mail is send and mail send failure occurs in second mail send, is the first mail send rollbacked !!! is there another method to do so???