how to use transaction in 3 Tier architecture

Question

I am doing Project in 3 Tier architecture. When i click save button, i want to fill 2 tables in database by using transaction in data access layer by using c#. i have 2 stored procedure for inserting for 2 tables.I filled one table and try to fill second table i got error, that time data wont fill in first table also.for that i am using transaction. but i am passing parameters from business layer to data access layer , so how to implement Transaction in that.
 please help me..

thanks in advance