ADO programming model using an object
The ADO's goal is to access, edit, and update data sources, and the programming model reflects the order in which the series of action necessary to complete this goal. ADO provides classes and objects to complete the following activities:
Connect to the data source and select Start a transaction. You can choose to create an object to represent the SQL command (Command). You can choose to specify columns, tables, and values as variable parameters in the SQL command. Execute commands (Command, Connection, or Recordset). If the command is returned, the row is stored in the cache (RECORDSET). You can choose to create a cache to sort, filter and locate the data (RECORDSET). By adding, deleting, or changing the row and column editing data (RECORDSET). Under appropriate cases, use the change in the cache to update the data source (RECORDSET). If you use a transaction, you can accept or reject changes made during the completion of the transaction. End the transaction.
