C#编程之事务用法

2019-10-29 21:36:07

字体：大中小

来源：转载

供稿：网友

这篇文章主要介绍了C#编程之事务用法,结合实例形式对比分析了C#中事务提交与回滚的具体实现技巧与相关注意事项,具有一定参考借鉴价值,需要的朋友可以参考下

本文实例讲述了C#编程之事务用法。分享给大家供大家参考，具体如下：

ado.net2.0的SqlTransaction使用方法

/////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); }

}