Visual Basic - Advanced - 4 Days

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 Conrol

•  Using an OLE DB Data Grid 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

• Deploying an Application

Working with Object Variables

• Understanding Classes and Objects

• Creating an Object Instance

• Comparing Late and Early Binding

• Destroying an Object

• Using an Object with Events

Creating Classes

• Creating a Class

•  Adding a New Class to a Project

•  Working with Class Module Events

•  Creating Class Properties

•  Creating Class Methods

•  Creating Class Events

Working with COM Components

• Understanding COM Components

• Referencing a COM Component

• Creating Objects from a COM Component

• Using a COM Component

Enhancing Classes

• Handling Class Errors

• Creating Named Constants

• Adding Descriptive Information

• Defining a Default Property

• Working with Collections

• Working with the Intrinsic Collection Class

• Looping Through Object Collections

• Creating a Collection

• Creating a Object Model

Creating COM Components

• Comparing Types of COM Components

•  Creating a COM Component Project

• Setting Class Module Properties for a Component

•  Declaring Friend Properties and Methods

•  Implementing a Component Class

•  Testing a COM Component

•  Compiling a COM Component

•  Registering a COM Component

Creating ActiveX Controls

• Understanding ActiveX Controls

•  Designing the User Interface

•  Creating Properties

•  Creating Methods

•  Creating Events

•  Creating Property Pages

•  Compiling an ActiveX Control Component

Packaging and Deploying with Components

•  Distributing Components Individually

•  Licensing an ActiveX Control

•  Compiling an Application

•  Packaging an Application

•  Deploying an Application