Transaction over multiple sqlDataSource

I am using 25 sqlDataSource controls on a single form and at a time their insert is called on button click.
Each sqlDataSource is having corresponding stored procedure.
What I want is that if any of the  SqlDataSource throws error while inserting then all previous insert done should be cancelled.

1. If I use sqlCommand object insted of sqlDataSource then this can be done by using following code:
 
    protected void Button1_Click(object sender, EventArgs e)
    {
        try
        {
            connection.Open();
            transaction = connection.BeginTransaction();

            SqlCommand1.ExecuteNonQuery();
  ...