Visual Basic Advanced - Part 1: Version 6.0

Data Access Programming (2 Days)

Prerequisites:

Visual Basic Introduction or a comfortable working knowledge of all the topics in that course is required. Access Introduction or equivalent experience is strongly recommended. SQL Introduction is suggested. Duration: This is a 2-day course

Course Content:

Understanding Data Access

Working with Relational Databases

Comparing Data Providers and Data Consumers

Connecting to Data Providers

Working with the Data View Window

Accessing Data with a Data Environment

Adding a Data Environment to a Project

Adding a Connection

Creating a Command

Binding Controls to a Data Environment Automatically

Programming with Data Environment Objects

Working with Recordsets

Binding Controls to a Data Environment Manually

Using an OLE DB DataCombo Control

Using an OLE DB DataGrid Control

Working with ActiveX Data Objects (ADO)

Understanding the ActiveX Data Object Model

Creating a Connection Object

Creating a Command Object

Creating a Recordset Object

Binding Controls to a Recordset Object

Specifying a Recordset Cursor Type

Executing SQL Statements

Modifying Data Using ADO

Locking Records for Updating

Editing Data Using Bound Controls

Editing Data without Binding Controls

Adding New Records

Handling Data Access Errors

Managing Transactions

Using the ADO Data Control (ADODC)

Adding the ADODC to a Project

Adding the ADODC to a Form

Setting a Data Source and Record Source

Binding Controls to the ADODC

Designing Data Reports

Adding a Data Report to a Project

Connecting to a Data Source

Adding Fields to a Data Report

Displaying the Report

Accessing Data on SQL Server

Connecting to an SQL Server Database

Running Stored Procedures

Comparing Client-Side and Server-Side Cursors

Using a Disconnected Recordset

Packaging and Deploying a Data Access Application

Using a Resource File

Compiling an Application

Packaging an Application

Distributing MDAC 2.0 and DCOM