Visual Basic 6 Programming: Business Applications with a Design Perspective

Table of Contents

Chapter 8 Database and the ActiveX Data Objects

• 8.1 Introduction to Database
  • Table definitions and RecordSets
  • Indexes, the Primary Key, and the Foreign key
  • Introduction to the SQL
• 8.2 Using the ADO Data Control
  • Data Control, DAO, and ADO
  • Working with the ADO Data Control
  • Binding Textbox Controls to the ADO Data Control
  • The DataGrid
  • The Hierarchical FlexGrid
  • Using the SQL with the ADO Data Control
  • Populating an Unbound Control
  • Using Unbound Controls for Input and Output
• 8.3 Using the ADO without the ADO Data Control
  • Adding the ADO Object Library to Your Project
  • Objects and Object Variables
  • Working with Recordsets by Code
  • Reworking the Phones Project
  • Coding the ADO with SQL
  • Other SQL Capabilities
  • Browsing Database Table Definitions (Schema)
• 8.4 Data Shaping: Hierarchical RecordSets
  • Syntax
  • The Provider and the Connection String
  • Referencing the Hierarchical Recordset
  • The "Complete" Code for the Authors-Titles Example More On Data Shaping
• 8.5 Using the Data Environment Designer
  • Example 1. Accessing the Authors Table and Binding A Hierarchical FlexGrid
  • Example 2. Creating a Hierarchical Recordset
• Summary
• Visual Basic Explorer
• Exercises
• Projects