MCSD：Visual Basic 6 Distributed Applications学习指南 英文原版

Table of Contents

Introduction

Chapter 1 Designing a distributed Solution

General Application Architecture

File Server Architecture

Client/Server Architecture

The Services Design Model

User Services

Data Services

Business Services

Architectural Options

Multiple-Tier design and Performance

Microsoft Transaction Server

Scalability

Transaction Support

Security

Data Source Availability with Microsoft Message Queue

Optimization of Database Roles

Decision-Support Systems

Online Transaction Processing Systems

The Balancing Act

Installing and Configuring Visual Studio 6 components

Installing and Configuring Visual Basic 6

Installing SQL Debugging

Installing and Using Microsoft visual SourceSafe

Review Questions

Chapter 2 Designing and Implementing the Data Tier

Designing he Data Tier

The Rules of Normalization

Denormalization

Creating and Managing Database Objects

Exploring Databases

Viewing and Modifying Tables

Retrieving and Modifying Data with SQL Statements

Retrieving Data with SQL

Modifying Data with SQL

Correlating Data with Join Statements

Using Transactions

Implementing Transactions in SQL Server 7

Creating Stored Procedures

Summary

Review Questions

Chapter 3 Accessing Databases with the ActiveX Data Objects

Ado Basics

Getting Comfortable with the ADO Object Model

Implementing the ADO Data Control

Implementing the ADO Model

Using the Connection Object

Using the Recordset Object

Opening a Recordset

Displaying Data in a Recordset

Modifying Data through a Recordset

Using the Command Object

Using Stored Procedures

Summary

Review Questions

Chapter 4 Designing and Implementing the Business Tire

Components Defined

Classes

Objects

Components

Designing Components

Collections and Objects

Designing Properties,Methods,and Events

The Nuts and Bolts

Creating Object Models

Exercise Scenario

Exercise Solution

Creation Components with Visual Basic6

The Visual Basic Component Project

Project Properties

Class Properties

Preparing the Component Environment

Adding Methods to a Component

Adding Properties

Adding Events

Compiling and Registering the Component

Using Visual Component Manager

Publishing a Component

Locating a Component

Reusing a Component

Summary

Review Questions

Chapter 5 Creating ActiveX Controls

Creating Simple ActiveX Controls

The ActiveX control Project

Creating the Visual Interface

Testing the Control

Adding Custom Properties,Methods,and Events

Adding Methods

Adding Properties

The ActiveX Control Life Cycle

Adding Events

Property Pages

Using The Property Page Wizard

Using Built-In Property Pages

ActiveX Controls and Data Binding

Creating Data Bound controls

Creating a Data Provider Control

Summary

Review Questions

Chapter 6 Designing and Implementing the Presentation Tier

Presentation Fundamentals:Forms,Controls,Events,and Data Display

Working with Forms

Working with controls

Working with Events

Advanced Interface Controls

Interactive presentation Features

Working with Menus

Working with Object collections and Arrays

Summary

Review Questions

Chapter 7 Creating a Data-Aware Client

Ensuring User-Tier Data Integrity

Field-Level Validation

Form-Level Validation

Modifying forms or controls Based on Input Values

Data Binding :Reaching Beyond the User Tier

Visual Basic Data Source Tools

Using Manually Bound controls to Display Data

Using the Data Environment to Connect a Data source

Using the Data Form Wizard to Create Forms with Bound controls

Summary

Review Questions

Chapter 8 Calling COM Components

Automation Basics

Binding

Calling COM Components

Object Variables

Automation External Objects

Calling Custom components

Communicating Asynchronously with components

Using Events

Using Callback Procedures

Events vs.Callbacks

Summary

Review Questions

Chapter 9 Using Microsoft Transaction Server

Transaction Server Fundamentals

Transaction Activity

Scalability

Security

Installing and configuring MTS

Definitions

Installing MTS

Managing MTS Security

Creating Components for MTS

Requirements of MTS Components

The context Object

Reporting Transaction Status

Adding Components to Packages

Working with Existing Packages

Summary

Review Questions

Chapter 10 Creating a Browser-Based Presentation Tier

HTML Overview

Structure Tags

Formatting Tags

List Tags

Form Tags

Special Tags

Using ActiveX Controls

Downloading ActiveX controls

Implementing ActiveX Controls

ActiveX Controls and Security

Implementing VBS Cript

VBScript Structures

Using VBScript with Objects

Creating Dynamic HTML Pages with Visual Basic

Creating Active Server Pages

Server process Architectures

Understanding Active Server Pages

Implementing Active Server Pages

IIS Applications and the WebClass

objects in an IIS Application

WebClass Events

A Walk-Through of an IIS Application

Where WebClasses Fit

Using Active Documents

Creating Active Documents

Coding the Active document

Where Active Documents Fit

Summary

Review Questions

Chapter 11 Creating Help Systems

HTML Help or WinHelp

Planning an Online Help System

Choosing a List of Topics

Creating HTML Files

Implementing a Help System

Using Microsoft HTML Help Workshop

Binding Forms and Controls to the Help Files

Passing Messages from Server components to the User

Summary

Review Questions

Chapter 12 Error Handling in the Distributed Application

Error Handling in the Client

Configuring Visual Basic for Error Handling

Identifying and Resolving Runtime Errors

Error handling in the component

Using the ADO Errors collection

Examining the Errors Collection

Summary

Review questions

Chapter 13 Application Testing and Analysis

the Debug Tools

Entering Break Mode

Setting Watch Expressions

Working in Break Mode

The Callstack

Debugging Distributed Application Elements

Project Groups

Debugging components and Controls

Summary

Review Questions

Chapter 14 Deploying a distributed Application

Using the visual Basic compiler

Compiling Project files

Using Conditional Complication Constants

Compiling from the Command Line

deployment Media and Methods

floppy Disk Deployment

CD-ROM Deployment

Network Deployment

Internet Deployment

Deploying Updates

Using the package and Deployment Wizard

Creating a Setup program

Deploying a Setup Package

Deploying and Configuring MTS Components and Clients

Using the DCOM configuration utility

Summary

Review Questions

Appendix A Answers to Review Questions

Appendix B Strategies for Successful Test Taking

/effective Study Techniques

Mnemonics

Repletion

Visualization

Meaning-Making

Test-Taking Skills

Before the exam

Selecting the Right Answer

Appendix C Microsoft SQL Server 7 Primer

Installing SQL Server

SQL Server 7Versions

Installing SQL Server

Using SQL Server Client Utilities

Service Manager

Client Network Utility

Server network Utility

Enterprise manager

Query Analyzer

Where to Get Additional Information

Clossary