Quick Tour with Visual Basic

Employee Form

Batch Insert Form

This quick tour is designed to get you started with Oracle Objects for OLE for Visual Basic. We use an example employee database application to show you how to code basic database operations such as navigating through data, adding, modifying, and querying records. A more advanced section is also included on how to perform batch inserts using parameter arrays and SQL statement objects.

The entire code for this example application is provided in the ORACLE_BASE\ORACLE_HOME\OO4O\VB\SAMPLES\QT\ directory.

This quick tour covers the following topics. You can also learn how to code a particular function by clicking the button in the Employee Form window.

Introduction

About the Employee Database Application

Getting Started: Steps to Accessing Oracle Data

Functions

Navigating Through Data

Adding Records

Updating Records

Deleting Records

Querying the Database

Inserting Rows in Batch

Using the Connection Pool Management Facility