Visual Basic 6 (VB6) Database Access management with ADO - Part 1

( Contents )

Chapter Objectives

1. Using data binding to display and manipulate data from a data source
   
   Data binding is the act of connecting a control in the programming environment directly to a field in a row in a Recordset so that users can directly view and edit the data by changing the control contents.

2. Accessing and manipulating a data source by using ADO and the ADO Data Control
   
   Chapter objectives for data access concentrate on programming with ADO (ActiveX Data Objects, defined at greater length throughout this chapter), including more automated ways to program with ADO (the ADO Data Control and the Data Environment Designer), the newest standard for data access from Microsoft programming environments.

3. Using the ADO Errors collection to handle database errors
   
   The ADO Errors collection is, as its name implies, a special structure furnished by ADO to give you information about the most recent error raised by ADO in your application.

This chapter and the following chapter discuss the basics of the ADO object model, how to bind controls to ADO data, and how to choose and manipulate ADO data connections.

Contents

1. Overview of OLE DB and ADO
   ADO and the ADO Object Model

2. Programming With Automated Data-Binding Tools
   Managing ADO Objects With the Data Environment Designer
   Adding Connection and Command Objects With the Data Environment Designer
   Binding VB Objects to Data Environment Objects
   Programming With a Data Environment Designer
   Accessing ADO Events for Objects Under a Data Environment

3. Accessing Data With ADO and the ADO Data Control
   Using the ADO Data Control
   Setting Up the ADO Data Control
   The ADO Data Control's EOFAction and BOFAction Properties
   Binding VB Controls to the ADO Data Control's Recordset
   Adding Records With the ADO Data Control
   Editing Existing Records With the ADO Data Control
   Canceling Pending Editing Changes on Bound Controls
   Programming Other Actions on the ADO Data Control's Recordset
   The ADO Control's Error Event
   Other Events of the ADO Data Control

4. Programming With ADO
   Initializing the Connection Object in Code
   Connection Object Events
   Initializing Command Objects in Code
   Recordsets
   Manipulating a Recordset's Data With Its Methods
   Referring to Recordset Field Contents
   Programmatically Reading a Record's Contents Into VB Controls
   Programmatically Writing VB Controls to a Record
   Updating a Record
   Canceling User Changes Before They Are Saved
   Adding a Record
   Deleting a Record
   Programmatically Navigating a Recordset
   Locating Records
   The Recordset's Bookmark Property
   Recordset Events
   Disconnected, Persistent, and Dynamic Recordsets
   Disconnected Recordsets
   Dynamic Recordsets
   Persistent Recordsets
   Using the ADO Errors collection