Transaction control in layered applicattion

I am developing a web application in 3 layer I am wondering if am able to use transaction control (Commit,Rollback) in it.

I am creating a connection object in DAL and closing it after use.
I have two classes Class1 and Class2 with a method to insert record.
DAL:   Class1.Insert() and  Class2.Insert()
BLL:   Class1BLL.Insert() and Class2BLL.Insert()

Now through BLL in Presentation layer I want to call Class1BLL.Insert() and in for loop Class2BLL.Insert().
But here I want to use transaction to ensure consistency. If anywhere something went wrong I want to rollback everything, otherwise commit.

...