OwlWrangler Redmond Weather About us


Home Up
  Contact Bill at
 

 

 

 

 

 

 

 

 

 

 

 

 

 


 


 

 

ADO Examples and
Best Practices


ADOEBPPublisher: Apress
Published: May 2000
Pages: 425
Disk: 1 CD
Level: Int/Adv
ISBN: 1-89311-516-X

Excerpt from  Chapter 5: ADO Command Strategies
Excerpt from  Chapter 9: Web-based Solutions

This work by William Vaughn is derived from years of experience working with independent front-line developers and the development teams at Microsoft. It is drawn from a compilation of suggestions, insights and working solutions to common (and some not so common) problems faced by developers. ADO Examples and Best Practices also focuses on addressing ADO problems at the root--through better designs and better coding practices. These suggestions yield far better performance--both for developers (they’re able to write better code more quickly), and for applications (they run faster, consuming fewer resources). 

Today, developers are faced with a dizzying cornucopia of choices when it comes to data access paradigms. ADO Examples and Best Practices makes implementation of the best of those technologies far easier--generally through working examples and discussions of what works and what doesn’t. “Best Practices” are those techniques developers have found to cause the least amount of overhead, problems and confusion. While some best practice techniques are quite simple to implement, other practices require considerable thought and forethought to enable. This is a developer’s book--full of hints, tips and notes passed on from those who show the medals and scars of battles won and lost. The book contains hundreds of examples illustrating how to establish connections, manage errors, execute queries and manage result sets. It also discusses how to deal with some of the most complex aspects of ADO including stored procedure management, ActiveX Server Page (ASP) coding, passing data from tier-to-tier and much more. 

This book will appeal to data access developers writing code on any platform--from simple single-user database systems, to client/server, to middle-tier, to Web-based development paradigms. In other words, anyone coding data access programs in the Microsoft Windows® architectures. While ADO Examples and Best Practices focuses on Visual Basic development and shows Visual Basic examples, its insights can help developers using any language-even C++ or Delphi write better ADO applications and components. The book does not assume the reader has in-depth ADO experience, nor will it bore the experienced user. This is done by explaining concepts completely from design to implementation and discussing techniques to enough depth that the professional ADO developer can gain valuable insight on the inner-workings of the interface.

ADO Examples and Best Practices includes a CD containing a wealth of examples drawn from the text and a wide assortment of other ADO samples. 

For reader reviews at angryCoder.com and Amazon.com and vbRAD.com . . .

European customers: visit Springer-Verlag, Apress's European book distributor

Hitchhiker's Guide to Visual Basic and SQL Server, 6th Ed.

HHG v6Publisher: Microsoft Press
Published: 09/09/1998
Pages: 1024
Disk: 1 CD
Level: Int/Adv
ISBN: 1-57231-848-1

Sample chapter: 
Chapter 28: Understanding ADO and OLE DB

The Hitchhiker's Guide To Visual Basic and SQL Server, Sixth Edition, is the definitive guide for developers who want to use Visual Basic to access Microsoft SQL Server. Whether you’re using earlier versions or the new Visual Basic 6.0 and the completely reengineered SQL Server 7.0 (which now runs on Microsoft Windows® 95 and Windows 98), this book will help you decide which of the constantly evolving data access options is best for your situation. To get the most out of this guide, you should have a working knowledge of Visual Basic, know how SQL Server is administered, and understand how to create SQL commands.

Author William Vaughn delivers the same depth and breadth of coverage that have made earlier editions of this book indispensable. Plus, he introduces innovations that may well change the way you think about data access:
• Data access techniques and alternative architectures
• Everything you need to know about the ActiveX® Data Objects (ADO), RDO, ODBC Direct, and DAO/Jet data access interfaces—and even the ODBC API and VBSQL legacy interfaces, now on the companion CD-ROM
• An entire section devoted to ADO, the new object-level interface to OLE DB architecture
• Complete information on designing and building Visual Basic applications and components, including making connections with, writing queries for, and retrieving data from SQL Server
• Visual Database Tools, which let you manage SQL Server data and data-centric applications more easily than ever
• The Data Environment Designer, the Data Object Wizard, and other new data access tools

Encyclopedic in breadth and filled with deep, practical insights, the Hitchhiker's Guide to Visual Basic and SQL Server, Sixth Edition, is packed with industrial-strength information—all in William Vaughn’s unique, reader-friendly style.