易采站长站为您分析C#编程之事务用法,结合实例形式对比分析了C#中事务提交与回滚的具体实现技巧与相关注意事项,具有一定参考借鉴价值,需要的朋友可以参考下
本文实例讲述了C#编程之事务用法。，具体如下：
ado.net2.0的SqlTransaction使用方法
- /////ado.net1.0中使用Transacation（事务) string connectionString = "database=Northwind;pwd=admin;uid=sa;server=DATABASE-VPCSQL2005";
- 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-VPCSQL2005";
- string connectionStringTwo = "database=Test;pwd=admin;uid=sa;server=DATABASE-VPCSQL2005"; 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;
