Visual Basic 6.0 分布式应用程序开发

About This Book
Intended Audience
Prerequisites
Geting Started
Hardware Requirements
Software Requirements
Course Overview
Features of This Book
Conventions Used in This Book
About The CD-ROM
Using this Book to Prepare for Cervification
Where to Find Specific Skills in This Book
The Microsoft Certified Professional Program
Microsoft Certification Benefits
Technical Support
About the Authors
Chapter 1:Application Design Concepts
About This Chapter
Before You Begin
Lesson 1:Planning a Distributed Solution
Overview of Microsoft Solutions Framework
The Solutions Design Model
Software Requirements
Multiple Developer Tools
Practice:Adding Visual SourceSafe to Visual Basic
Lesson 2:Selecting an Application Architecture
Understanding Application Structure
Developing a Distributed Application
Lesson Summary
Lesson 3:Using Visual Database Tools
Using Visual Database Tools with Visual Studio
Deriving Physical Design Using Visual Database Tools
Practice:Tour of the SQL Server Pubs database
Lesson Summary
Summary
Lab:Using Visual Component Manager
Review
Chapter 2:Creating the User Interface
About This Chapter
Before You Begin
Lesson 1:Overview of User Interface Elements
Controls
Setting Properties
Managing Events
Standard Form Events
Using Collections
Practice:Using the Collection Object’s Add Method
Lesson Summary
Lesson 2:Navigation and Validation
Developing Navigation
Validating Data
Lesson Summary
Summary
Lab:Creating a User Interface Dynamically
Exercise 1:Creating the User Interface
Exercise 2:Validating User Input
Exercise 3:Adding and Coding a Menu Bar
Exercise 4:Dynamically Adding Controls
Review
Chapter 3:Creating COM DLLs with Visual Basic
About This Chapter
Before You Begin
Lesson 1:Creating Class Modules
Creating Properties,Methods,and Events
Events
Call-Back Methods
Enumerations
Practice:Using the Class Builder Utility
Lesson Summary
Lesson 2:Using Class Modules
Using the Object Browser
Practice:Viewing thd CFile Class
Instantiating a Class
Practice:Using a Component’s Properties,Methods,and Events
Lesson Summary
Lesson 3:Creating COM DLLs and EXEs
ActiveX Project Templates
Setting ActiveX DLL Project Properties
Setting Class Properties in a Component
Registering and Unregistering Components
Testing and Debugging Components
Practice:Using a Project Group to Test a COM DLL
Lesson Summary
Summary
Lab:Creating a COM DLL
Review
Chapter 4:Advanced COM Programming with Visual Basic 6.0
About This Chapter
Before You Begin
Lesson 1:Creating Custom Interfaces
Interface-Based Programming
Interface and Visual Basic
Practice:Viewing a Type Library with the OLE View Tool
Creating Your Own Interfaces
Polymorphism
Version Compatibility
Lesson Summary
Lesson 2:Developing a Custom Object Model
Custom Business Objects
Creating an Object Model
Collection Classes
Visual Basic Object Modeling Tools
Practice:Creating Object Moedls with the Class Builder Utility
Lesson Summary
Summary
Lab:Advanced COM Programming with Visual Basic
Exercise 1:Creating the IEmployee Interface
Exercise 2:Implementing the IEmployee Interface
Exercise 3:Testing the PayRoll Component
Review
Chapter 5:Introducing ActiveX Data Objects
About This Chapter
Before You Begin
Lesson 1:Overview of Universal Data Access
Overview of Universal Data Access
ActiveX Data Objects
Lesson Summary
Lesson 2:Introduction to the ADO Object Model
Creating ADO Objects
The ADO Connection Object
The ADO Connection Object
The ADO Recordset Object
Lesson Summary
Lesson 3:Using the Data Environment
The Data Environment Environment
Practice:Data Binding Using a Data Environment
Lesson Summary
Summary
Lab:Using the Data Environment and ADO
Review
Chapter 6:Accessing Data with ActiveX Data Objects
About This Chapter
Before You Begin
Lesson 1:Managing Connections to a Data Source
Defineng the ADO Connection Object
Establishing a Connection
Practice:Programmatically Creating a Connection
Using the ADO Command Object
Lesson Summary
Lesson 2:Returning Records from a Data Source
Using the ADO Recordset Object
Accessing Records in a Recordset
Binding Controls to ADO Recordsets
Creating Multiple Recordsets
Creating Programmatic Recordsets
Lesson Summary
Lesson 3:Navigating Records
ADO Navigation Properties
ADO Navagation Methods
Practice:Navigating an ADO Recordset
Lesson Summary
Lesson 4:Modifying Records
Modifying Records with SQL stateiments
Modifying Records in a Recordset
Lesson Summary
Lab:Accessing Data Using ADO Objects
Exercise 1:Creating the COM Component that Uses ADO
Exercise 2:Creating the Client
Review
Chapter 7:Advanced Database Topics
About This Chapter
Before You Begin
Lesson 1:Introduction to Transactions
Definition of a Transaction
Transactions and ADO
Types of Transactions
Coding Efficient Transactions
Transact-SQL
Lesson Summary
Lesson 2:Using Disconnected Recordsets
Specifying the CursorLocation Property
Disconnecting from a Data Source
Reconnecting to a Data Source
Practice:Working With Disconnected Recordsets
Lesson Summary
Lesson 3:Asynchronous Operations
Connecting Asynchronously to a Data Source
Using ADO Events
Asynchronously Executing a Command
Asynchronously Fetching Results
Lesson Summary
Summary
Lab:Using Disconnected Recordsets
Review
Chapter 8:Using Stored Procedures
About This Chapter
Before You Begin
Lesson 1:Overview of Stored Procedures
Advantages of Using Stored Procedures
Stored Procedures in a Two-Tier Model
Stored Procedures in an N-Tier Model
Stored Procedures and the Command Object
Practice:Calling a Stored Procedure
Lesson Summary
Lesson 2:Using Stored Procedures
Creating Simple Stored Procedures
Using Parameters in Stored Procedures
Generating Multiple Recordsets
Implementing Transactions
Debugging Transact-SQL
Lesson Summary
Summary
Lab:Creating adn Calling a Stored Procedure
Exercise 1:Creating a Data Access Component
Exercise 2:Creating the Front-End Application
Review
Chapter 9:Using Microsoft Transaction Server
About This Chapter
Before You Begin
Lesson 1:Overview of Microsot Transaction Server
Developing N-tier Applications with MTS
MTS Services
An MTS Application Example
Lesson Summary
Lesson 2:Installing and Configuring Microsoft Transaction Server
MTS System Requirements
Configuring Your MTS Server
Configuring Your Development Computer
Lesson Summary
Lesson 3:Creating Solutions Using Microsoft Transaction Server
Designing MTS Components
Creating MTS Components
Using Transactions in MTS Components
Deploying MTS Components
Lesson Summary
Summary
Lab:Creating and Deploying MTS Components
Exercise 1:Setting up the Chateau Database
Exercise 2:Creating the Client Application
Exercise 3:Creating the Chateau COM DLL
Exercise 4:Deploying Your COM DLL with MTS
Review
Chapter 10:Implementing Security in the Enterprise
About This Chapter
Before You Begin
Lesson 1:Overview of Security
Principles of Security
Windows NT Security Model
Enterprise Application Security
Lesson Summary
Lesson 2:Implementing SQL Server Security
Overview of SQL Server Security
Comparison of SQL Server Security Modes
Lesson Summary
Lesson 3:Implementing Security in Microsoft Transaction Server
Understanding Roles and Security
Setting Package Properties
Using Programmatic Security
Lesson Summary
Lesson 4:Implementing COM Security Using DCOMCNFG
Overview of Distributed COM
Deploying a COM EXE
Creating Remote Server Files
Registering a Remote Component on a Client Computer
Practice:Registering a Component with Clireg 32.exe
Lesson Summary
Summary
Lab:Using Programmatic Security in an MTS Component
Exercise 1:Adding a Role to your MTS Component
Exercise 2:Writing Code to Implement Programmatic Security
Review
Chapter 11:Debugging and Error Handing
About This Chapter
Before You Begin
Lesson 1:Handling Errors in an Application
Using Visual Basic Debugging Tools
Creating Error Handlers
Lesson Summary
Lesson 2:Testing and Debugging Middle-Tier Components
Testing Code Components
Debugging MTS Components
Handling Errors in MTS Components
MTS Components Debugging Limitations
Lesson Summary
Lab:Interactively Debugging an MTS Component
Exercise 1:
Review
Appendix A:Questions and Answers
Appendix B:Creating ActiveX Controls
Appendix C:Using the ADO Data Coutrol
Appendix D:Creating Internet Applications
Appendix E:Preparing a Distributed Application for Deployment
Glossary
Index