On Error GoTo ErrHandle Dim CN As New ADODB.Connection '定义数据库的连接 ' Dim Rs As New ADODB.Recordset CN.ConnectionString = "Provider=sqloledb;Data Source=pmserver;Initial Catalog=northwind;User Id=sa;Password=sa;" CN.BeginTrans
CN.Execute "insert into table1 ........" CN.Execute "insert into table2 ........"
CN.CommitTrans Exit Sub ErrHandle: CN.RollbackTransEnd Sub
' Dim Rs As New ADODB.Recordset
CN.ConnectionString = "Provider=sqloledb;Data Source=pmserver;Initial Catalog=northwind;User Id=sa;Password=sa;"
CN.BeginTrans
CN.Execute "insert into table1 ........"
CN.Execute "insert into table2 ........"
CN.CommitTrans
Exit Sub
ErrHandle:
CN.RollbackTransEnd Sub
BeginTrans
回滚
RollbackTrans
提交事务
CommitTrans