Events
Get certified in Microsoft Fabric—for free!
19 Nov, 11 pm - 10 Dec, 11 pm
For a limited time, the Microsoft Fabric Community team is offering free DP-600 exam vouchers.
Prepare nowThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Two ADO objects can raise events: the Connection object and the Recordset object. The ConnectionEvent family pertains to operations on the Connection object, and the RecordsetEvent family pertains to operations on the Recordset object.
Connection Events: Events are issued when a transaction on a connection begins, is committed, or is rolled back; when a Command executes; when a warning occurs during a Connection Event operation; or when a Connection starts or ends.
Recordset Events: Events are issued around asynchronous fetch operations as well as when you navigate through the rows of a Recordset object, change a field in a row of a Recordset, change a row in a Recordset, open a Recordset with a server-side cursor, close a Recordset, or make any change whatsoever in the Recordset.
The following tables summarize the events and their descriptions.
ConnectionEvent | Description |
---|---|
BeginTransComplete, CommitTransComplete, RollbackTransComplete | Transaction Management - Notification that the current transaction on the connection has started, committed, or rolled back. |
WillConnect, ConnectComplete, Disconnect | Connection Management - Notification that the current connection will start, has started, or has ended. |
WillExecute, ExecuteComplete | Command Execution Management - Notification that the execution of the current command on the connection will start or has ended. |
InfoMessage | Informational - Notification that there is additional information about the current operation. |
RecordsetEvent | Description |
---|---|
FetchProgress, FetchComplete | Retrieval Status - Notification of the progress of a data retrieval operation, or that the retrieval operation has completed. These events are only available if the Recordset was opened using a client-side cursor. |
WillChangeField, FieldChangeComplete | Field Change Management - Notification that the value of the current field will change, or has changed. |
WillMove, MoveComplete, EndOfRecordset | Navigation Management - Notification that the current row position in a Recordset will change, has changed, or has reached the end of the Recordset. |
WillChangeRecord, RecordChangeComplete | Row Change Management - Notification that something in the current row of the Recordset will change, or has changed. |
WillChangeRecordset, RecordsetChangeComplete | Recordset Change Management - Notification that something in the current Recordset will change, or has changed. |
ADO Event Instantiation by Language ADO Events Event Parameters How Event Handlers Work Together Types of Events
Events
Get certified in Microsoft Fabric—for free!
19 Nov, 11 pm - 10 Dec, 11 pm
For a limited time, the Microsoft Fabric Community team is offering free DP-600 exam vouchers.
Prepare now