Sqldatasource Multiple Insert

Hi all,

I have few insertions statements in one datasource insert command, which i use for my user creation process adding new billing info shipping info and so on.

I've put this code in createuserwizard usercreated step with a try catch code. On the insertion if it doesnt work it deletes the user account.

Well lets say the first insertion went trough with out any problems, but the second one got blocked or didnt work length or any wierd on controled issue.

I was thinking of putting begin transaction end transaction statements in front and end of the statements but this can prevent the insert not to return error, which will prevent try catch to fire?

Basicly the idea is to do all insertions with the user creation, and if one goes down all the others gets reversed. (if possible single sqldatasource, just to make the code look clean)