ADO Examples
and
Best Practices
Publisher:
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.
Publisher:
Microsoft Press
Published: 09/09/1998
Pages: 1024
Disk: 1 CD
Level: Int/Adv
ISBN: 1-57231-848-1Sample 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. |