Rollback transaction and commit

See more:

C#

C#4.0

Please see the following code snippet. I want that if "AddPersonalRecord" fails due to any reason or "AddOfficialRecord" fails, the changes done to the database must be rolled back. I am using SQL Server 2005 express edition. The methods, AddPersonalRecord and AddOfficialRecord, contains Insert Statements to insert record in the table.

I want something like:

if (answer == "yes")
{
Begin Transaction();
AddPersonalRecord();
AddOfficialRecord();
}