A book/CD-ROM package for mastering Microsoft ActiveX Data Objects (ADO) and exploiting the Universal Data Access in ADO. Explains the ADO object model, then focuses on building proficiency with ADO programming techniques for updating databases, accessing data in traditional stores and Internet applications, and extending database applications to the Web. Includes code and frequently asked questions. The CD-ROM contains sample files and additional documentation.
Written for the intermediate to advanced Windows programmer, David Sceppa's
Programming ADO offers an expert's view of developing with this powerful--and occasionally tricky--database library. Filled with tips and suggested best practices for building robust database programs, this title provides a useful real-world perspective to effective coding with ADO.
This book is part reference, offering full coverage of all objects in ADO, and part programming tutorial, describing every object, property, collection, method, and event in this library, including ADOX and JRO in an appendix. Instead of whole programs, the author uses short code excerpts written in Visual Basic to illustrate key points. Complete sample applications are available on the accompanying CD-ROM.
Throughout this text, Sceppa shows off his expert knowledge of ADO. Standout sections here include examples of connecting to databases effectively, different strategies for querying and updating databases, and a nice explanation of disconnected recordsets. The discussion of the various cursor types available in ADO is also a must-read for any serious ADO developer. (Choosing the right cursor type for your project, it turns out, is not as easy as it appears.) Each section ends with "Questions That Should Be Asked More Frequently" in which the author invites you to think carefully about the ways you use ADO.
Later sections here turn to the powerful ADO Cursor Engine and the newer Record and Stream classes, which allow programmers to "persist" recordsets to files (and even XML). There are plenty of tips for handling record conflicts within real-world, multi-user databases. Once again, although ADO looks easy, there is plenty to worry about when multiple users access records frequently. This book shows you how to write more robust database applications.
Filled with time-saving programming expertise, Programming ADO fills a valuable niche for any developer who wants to start working with ADO effectively. --Richard Dragan
Topics covered: ActiveX Data Objects (ADO) overview and tutorial; Data Access Objects (DAO) vs. ADO; the ADO object model and version 2.5 enhancements; Connection properties, collections, methods, and events; connection strings; connecting to OLE DB providers; Recordset properties, collections, methods, and events; Command and Parameter properties, collections, and methods; using ADO Record and Stream objects; ADO cursor types and performance hints; strategies for updating databases; programming with the ADO Cursor Engine (programming tips, concurrency issues); handling database conflicts; persisting recordsets; hierarchical recordsets and data shaping; introduction to COM; passing ADO recordsets between processes; the Remote Data Service (RDS); ADO Extensions (ADOX) for manipulating database structures; and the Jet Replication Object (JRO).
