Option Explicit Dim WithEvents Cn As ADODB.ConnectionPrivate Sub Cn_CommitTransComplete(ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pConnection As ADODB.Connection) 'do Something End SubPrivate Sub Form_Load() Set Cn = New ADODB.Connection Cn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=angu;Data Source=sicsoft-k1phkl3;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=XHCHEN;Use Encryption for Data=False;Tag with column collation when possible=False"Cn.BeginTransCn.CommitTrans End Sub
我不知道withevents应该放在哪?
Dim WithEvents Cn As ADODB.ConnectionPrivate Sub Cn_CommitTransComplete(ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pConnection As ADODB.Connection)
'do Something
End SubPrivate Sub Form_Load()
Set Cn = New ADODB.Connection
Cn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=angu;Data Source=sicsoft-k1phkl3;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=XHCHEN;Use Encryption for Data=False;Tag with column collation when possible=False"Cn.BeginTransCn.CommitTrans
End Sub