C#编程之事务用法

/////ado.net1.0中使用Transacation（事务)string connectionString = "database=Northwind;pwd=admin;uid=sa;server=DATABASE-VPC//SQL2005";using (SqlConnection conn = new SqlConnection(connectionString)){  conn.Open();  SqlTransaction transaction = conn.BeginTransaction();  try  {   using (SqlCommand cmd = new SqlCommand())   {    cmd.Connection = conn;    cmd.CommandType = CommandType.Text;    cmd.CommandText = "";    cmd.Transaction = transaction;    cmd.ExecuteNonQuery();    transaction.Commit();//提交事务   }  }  catch  {   transaction.Rollback();//事务回滚  }/////2.0中使用事务string connectionString = "database=Northwind;pwd=admin;uid=sa;server=DATABASE-VPC//SQL2005";string connectionStringTwo = "database=Test;pwd=admin;uid=sa;server=DATABASE-VPC//SQL2005";using (TransactionScope transaction = new TransactionScope())//使用事务{  try  {   using (SqlConnection conn = new SqlConnection(connectionString))   {    using (SqlCommand cmd = new SqlCommand())    {     cmd.CommandText = "insert into [member] (name) values ('test')";     cmd.CommandType = CommandType.Text;     cmd.Connection = conn;     conn.Open();     cmd.ExecuteNonQuery();    }   }   using (SqlConnection conn = new SqlConnection(connectionStringTwo))   {    using (SqlCommand cmd = new SqlCommand())    {     cmd.CommandText = "insert into [member] (name) values ('test')";     cmd.CommandType = CommandType.Text;     cmd.Connection = conn;     conn.Open();     cmd.ExecuteNonQuery();    }   }   transaction.Complete();//就这句就可以了。  }  catch (Exception ex) { MessageBox.Show(ex.Message); }}