VB 6 Database Programming

1
VB 6 Database Programming

• Chapters 2 and 3

2
Chapters 2 and 3 Tutorial

• Read and Complete all of Chapters 2 and 3

3
ADOActiveX Data Objects

• ADO Data Control
• Use to connect our program to a database (like we
  did with DAO)
• Requires
• Visual Studio Service Pack 4 (or higher)
• Project References Microsoft ActiveX Data
  Objects 2.5 Library (or newer)
• Refer to Book Errata page 1

4
VB Data Form Wizard

• Only available with ADO
• Quick way to create a BASE form and code
• Add enhancements to make it more flexible and
  bullet-proof

5
The Recordset andBound Controls

• Database engine builds a Recordset in memory to
  work with
• Changes to the Recordset are saved in the
  database when moving to a different record
• VB includes several data-bound ActiveX controls
  (see lists p 41,42 and 89)

6
DAO Controls

• P 98 - Parent/Child Data Control Relationship
• P 104 - Masked Edit Control

7
ADO Controls

• P 105 - Add Components/Controls to tool box
• (be careful - choose those with OLEDB)
• Microsoft ADO Data control 6.0 (OLEDB)
• Microsoft DataList Controls 6.0 (OLEDB)
• P 108 When selecting Provider choose
• Microsoft Jet 4.0 OLE DB Provider (or higher)