3. 事务处理 可以三种方式 启用事务处理: 一: 数据库事务 指在数据库端代码理启用事务, 如 create produce testTrans AS Being TRANSACTION update taba set ... update tabb set ... COMMIT TRANSACTION .... exception ROLLBACK TRANSACTION ....
二: ADO.NET 事务
... cma= new sqlcommand(““ ,con ) cmb=new sqlcommand(““,con) con.open objTransaction=con.BeginTransaction cma.Transaction =objTransaction cmb.Transaction=objTransaction try cma.exec.... cmb.exec..... objTransaction.Commit catch ex as exception objTransaction.RollBack ... finally con.close() ....