
Amazon.com
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 class
Read more...