C# 事务

using  System;
using  System.Collections.Generic;
using  System.ComponentModel;
using  System.Data;
using  System.Drawing;
using  System.Text;
using  System.Windows.Forms;
using  System.Data.SqlClient;

namespace  事务范例
{
     public  partial  class  Form1 : Form
    {
         public  Form1()
        {
            InitializeComponent();
        }

         public  SqlConnection ConnectDB()
        {
             string  MySqlConnection  =   " user id=sa;password=sa;Database =RSS;data source=127.0.0.1;Connect Timeout=30 " ;
            SqlConnection conn  =   new  SqlConnection(MySqlConnection);
             return  conn;

        }


         private   void  button1_Click( object  sender, EventArgs e)
        {
            SqlConnection conn  =  ConnectDB();
            SqlTransaction tran;
             try
            {
                conn.Open();
                tran  =  conn.BeginTransaction();
            }
             catch
            {
                 return ;
            }
             try
            {
                SqlCommand cmd  =   new  SqlCommand( " delete from rss where newsAuthor='未知' " , conn);
                cmd.Transaction  =  tran;
                cmd.ExecuteNonQuery();
                tran.Commit();
            }
             catch
            {
                tran.Rollback();
                 return ;
            
            }
             finally
            {
                 if  (conn.State  ==  ConnectionState.Open)
                {
                    conn.Dispose();
                    conn.Dispose();
                }
            }
            MessageBox.Show( " OK " );

        }
    }
}