ADO Cheat Sheets

ADO Quick Reference is a web based collection of reference source for the nine ADO (ActiveX Data Objects) objects and the three RDS (Remote Data Services) objects. The web masters and developers can retrieve the contents directly by selecting the reference through various objects. This reference is also available in a downloadable PDF format for offline viewing.

Sun ONE Active Server Pages includes ActiveX Data Objects (ADO) for connecting ASP applications to databases. ADO is a set of objects that provide a mechanism to access information from ODBC-compliant data sources.

ADO API Reference,RDS API Reference, ADO MD API Reference, ADOX API Reference

CIS 213 ADO Cheat Sheet

The table provided below is intended to be a quick reference for determining how to map DAO properties and methods to ADO, ADOX, and JRO properties and methods. However, it is not intended to imply a direct, one-to-one mapping between the properties and methods listed. There may be subtle, or not so subtle, differences between the mapped properties and methods. For more detailed information on the ADO, ADOX, and JRO properties and methods see the documentation for the object model. Use the information provided earlier in this document to map the code for common tasks that are performed using DAO to ADO, ADOX, and JRO code.

This Quick Reference is now available for purchase in PDF format for easy off-line viewing and printing. Fully indexed for ease of navigation, this is an invaluable resource for all web developers. Click the icon above to purchase this Quick Reference.

This cheatsheet image will help you understand grabbing data from forms, creating a SQL statement in ASP, and using ADO to read/write to your databases.

Quick Guide for using ADO.NET (part 1: Data Grids and Individual Text Box Navigation) ... this is an MS Word document.

The ADO Command object is used to execute a single query against a database. The query can perform actions like creating, adding, retrieving, deleting or updating records. If the query is used to retrieve data, the data will be returned as a RecordSet object. This means that the retrieved data can be manipulated by properties, collections, methods, and events of the Recordset object. The major feature of the Command object is the ability to use stored queries and procedures with parameters.