.NET 事务处理

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.OleDb;
namespace TransactionTest
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        private OleDbTransaction transaction;
        protected void Page_Load(object sender, EventArgs e)
        {



        }
        protected void InserData()
        {
            OleDbConnection conn = new OleDbConnection("Provider=MSDAORA;Data Source=gerry;User ID=gerry;password=pwd");
            OleDbCommand cmd1 = conn.CreateCommand();
            conn.Open();
            transaction = conn.BeginTransaction();
            cmd1.Transaction = transaction;
            try
            {
                cmd1.CommandText = "insert into wms_brw_ng_list values('測試事務處理1')";
                cmd1.ExecuteNonQuery();
                cmd1.CommandText = "insert into wms_brw_ng_list values('測試事務處理2')";
                cmd1.ExecuteNonQuery();
                cmd1.CommandText = "insert into wms_brw_ng_list values('測試事務處理3測試事務處理3測試事務處理3測試事務處理3測試事務處理3測試事務處理3')";//超出字段长度，抛异常
                cmd1.ExecuteNonQuery();
                transaction.Commit();
                conn.Close();
            }
            catch (Exception ex)
            {
                transaction.Rollback();
                Response.Write("<script>alert('" + ex.Message + "')</script>");

            }
            finally
            {
                conn.Close();
            }
        }
        protected void Button1_Click(object sender, EventArgs e)
        {
            InserData();
        }
    }
}