How to Handle Single Transaction,Commit, RollBack

Question

How to Handle Single Transaction,Commit, RollBack For multiple connections in ADO.net.

 

Actually I have Multi level  Hierarchal Models like:

 

Class1{ 

List

} 

Class2{

List

List

Class5 

}

Class3{

List 

}

Class4{

}

Class5{

}

Class6{

} 

 

There are six different Data Tables in DataBase for each and every class. For that  i written 6 different Stored procedures. Now i am trying to insert data , While inserting if Exception is occuring in Any one of the Child table, then transaction should RollBack the Resut. I am not getting How to do this. Please help me in this.