VB6 beginners tutorial - Learn VB6

Advanced VB6 tutorial - Learn Advanced VB6

Systems Analysis - System analysis and Design tutorial for Software Engineering

You are here: Visual Basic > Advanced VB6 tutorial > Chapter 8

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.


  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
    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


Get Started >>

Home | About Us | Privacy Policy | Contact Us

Copyright © | All Rights Reserved