ADO Examples and Best Practices

ADO (Active Data Objects) is how the millions of Visual Basic programmers hitch onto Microsoft's amazing "Universal Database Access" strategy. But power breeds complexity, and using ADO isn't trivial! This book is based on best-selling author Bill Vaughn's years of experience working with front-line data access developers and the development teams at Microsoft itself. Now, this Microsoft veteran translates his insights and collected wisdom of over a decade at Microsoft into working solutions for the common (and some not so common) data-related problems developers face every day. ADO Examples and Best Practices focuses on addressing data problems at the root - through better designs and better ADO coding practices. These suggestions often yield far better performance - both for the developer (who is able to write better code more quickly), and for the application (it runs faster with less resources). About the Author: William R. Vaughn is currently a Developer Trainer at Microsoft. He has taught, written, lectured, sold, supported, designed, coded, managed and cried over mainframe and microcomputer systems and software for 28 years. He has been at Microsoft since 1986 and has held positions ranging from writing, teaching and managing trainers at the Microsoft University (MSU) to being Visual Basic Enterprise Product Manager. During his last two years at Microsoft he has been with the Internal Technical Education group teaching Microsoft employees themselves. While there he developed and taught courses on Visual Basic, data architectures, and ActiveX Data Objects (ADO). - Focuses on addressing data problems at the root - through better designs and ADO coding practices
- Offers insights and collected wisdom from over a decade at Microsoft
- No-nonsense writing spiced by witty asides and great code
ADO is how the millions of Visual Basic programmers hitch onto Microsoft's Universal Database Access strategy. But power breeds complexity and ADO isn't trivial! This book is based on best-selling author Bill Vaughn's years of experience working with front-line data access developers and the development team at Microsoft itself. Now, this Microsoft veteran collects his insights and collected wisdom into working solutions for the common, and uncommon, data-related problems developers face every day. His suggestions promise to yield far better performance - both for the developer and the application.

Author Biography: William R. Vaughn is currently a Developer Trainer at Microsoft. He has taught, written, lectured, sold, supported, designed, coded, managed, and cried over mainframe and microcomputer systems and software for 28 years. He has been at Microsoft since 1986 and has held various positions from writing, teaching, and managing trainers at the Microsoft University (MSU) to being Visual Basic Enterprise Product Manager. During his last two years at Microsoft he has been with the Internal Technical Education group teaching Microsoft employees themselves. While there he has developed and taught courses on Visual Basic, data architectures, and ActiveX Data Objects (ADO).

Visual Basic database developers are faced with a dizzying cornucopia of choices when it comes to data access paradigms. The purpose of this book is to make the choice and implementation of the best of those technologies far easier. It does this through working examples and numerous discussions of what works and what does not. Vaughns "Best Practices" are the techniques that developers need to know because they cause the least amount of overhead, problems and confusion. While some are quite simple to implement, other "Best Practices" require considerable thought and planning. This is a developers bookfull of hints, tips, and notes passed on from those who show the medals and scars of battles won and lost. Front Matter....Pages i-xvii Working with ADO....Pages 1-9 Introduction to ADO....Pages 11-16 Creating ADO Objects....Pages 17-20 Getting Connected....Pages 21-69 ADO Command Strategies....Pages 71-116 Recordset Strategies....Pages 117-188 Manipulating Your Recordset....Pages 189-238 Passing Resultsets Between Layers....Pages 239-280 Web-based Solutions....Pages 281-302 Getting Your Data into Shape....Pages 303-318 Data Access Tips and Techniques....Pages 319-335 ADO and the Visual Database Tools....Pages 337-354 SQL Server 2000 and ADO 2.6....Pages 355-362 Back Matter....Pages 363-374 This text focuses on addressing data-related problems at the root - through better designs and better ADO coding practices. The suggestions are geared toward the yield of better performance both for the developer and the application. CD-ROM contains: Examples from texts -- Sample programs -- Visual Basic Add-ins -- Reference materials