ADO.NET级别的事务
http://images.cnblogs.com/OutliningIndicators/ContractedBlock.gifhttp://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gifView Code <div id="cnblogs_code_open_1c8413dd-3acc-42c6-8811-9493bf10cfd9" class="cnblogs_code_hide"> 1string sqlcon = "server=.;database=webSystem;uid=sa;pwd="; 2 SqlConnection myConnection = new SqlConnection(sqlcon);//建立数据库连接对象 3 myConnection.Open(); 4 5 //启动一个事务 6 SqlTransaction sqltrans = myConnection.BeginTransaction(); 7 8 //为事务创建一个命令 9 SqlCommand cmd = new SqlCommand();10 cmd.Connection = myConnection;11 cmd.Transaction = sqltrans;12 try13 {14 cmd.CommandText = "update dbo.Sys_LoginUser set UserName='allen' where UID='19'";15 cmd.ExecuteNonQuery();16 cmd.CommandText = "update dbo.Sys_LoginUserset URealName='wankui' where UID='19'";17 cmd.ExecuteNonQuery();18 sqltrans.Commit();//提交，为了事务处理可以成功完成必须条用SqlTransaction的commit()方法19 Response.Write("两条数据修改成功");20 21 }22 catch (Exception ex)23 {24 sqltrans.Rollback();//如果发生错误，回滚25 Response.Write(ex);26 }27 finally28 {29 myConnection.Close();//关闭数据库连接30 }
页:
[1]