C#中的事务处理

using System.Data.SqlClient;

using System;

namespace TransactionTest

{

public class Program

{

static void Main(string[] args)

{

string str = "server = .;database=Flight;uid=sa;pwd=1234";

Transaction trans = new Transaction();

trans.RunSqlTransaction(str);

}

}

public class Transaction

{

public Transaction()

{

}

public void RunSqlTransaction(string str)

{

//创建连接

SqlConnection myConnection = new SqlConnection(str);

//打开连接

myConnection.Open();

//创建命令

SqlCommand myCommand = new SqlCommand();

//开始事务

SqlTransaction myTransaction = myConnection.BeginTransaction();

//指定事务和连接对象给myCommand

myCommand.Connection = myConnection;

myCommand.Transaction = myTransaction;

string insertStr1 = "insert into flightInfo values ('1234','济南航空公司',100,'济南','青岛')";

string insertStr2 = "insert into flightInfo values ('12344','上海航空公司',100,'上海','青岛')";

try

{

myCommand.CommandText = insertStr1;

//执行更新

myCommand.ExecuteNonQuery();

myCommand.CommandText = insertStr2;

//执行更新

myCommand.ExecuteNonQuery();

//提交事务

myTransaction.Commit();

//默认情况下,事务不提交则回滚

Console.WriteLine("两条记录插入成功");

}

catch (Exception ex)

{

try

{

//回滚事务

myTransaction.Rollback();

}

catch (Exception ex1)

{

Console.WriteLine(ex1.ToString());

}

Console.WriteLine(ex.ToString());

}

finally

{

myConnection.Close();

}

}

}

}

转自：http://blog.163.com/pengpeng_614/blog/#m=0&t=1&c=fks_087067093083088069093095086095085081086067083087080074