ADO.NET2.0 TransactionScope对象管理事务

using (TransactionScope ts = new TransactionScope())

{

    using (SqlConnection conn = new SqlConnection (Connstring))

     {

                         SqlCommand cmd = new Sqlcommand(cmdtext,conn);

                          cmd.Connection.Open();

              try

               {

               cmd.ExecuteNonQuery();

                 }

                  catch (SqlException ex)

                    {

                   response.write (ex.Message);

                      }

         }

ts.Complete();

}