Create and destroy connections to data sources and respond to events associated with the Connection object. Create commands that build queries or access queries, tables, or stored procedures in a database. Create recordsets and use them to view retrieved data. Use the ADO Error collection to trap and handle errors. Sort and filter records. Search records using ADO navigation methods. Insert, delete, and update record data. Connect to a secured database system and understand how to protect the data within from corruption, once connected. Choose suitable cursors for recordsets that balance application performance with features. Execute stored procedures on a database system through the ADO command object

• The ADO Object Model
• The Connection Object
• The Command Object
• The Recordset Object
• ADO Errors
• Updating and Editing Data Records with ADO

ADO Properties and Methods

• Modifying Data Records
• Disconnected Recordsets
• Advanced Data Access with ADO

Working with SQL Server Security

• Using ADO Cursors
• Maintaining Data Integrity Through ADO
• Running Stored Procedures with ADO