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

Practice:Adding Visual SourceSafe to Visual Basic

Multiple Developer Tools

Lesson Summary

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

Practice:Tour of the SQL Server Pubs database

Deriving Physical Design Using Visual Database Tools

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

Developing Navigation

Lesson 2:Navigation and Validation

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

Call-Back Methods

Events

Enumerations

Practice:Using the Class Builder Utility

Lesson Summary

Lesson 2:Using Class Modules

Using the Object Browser

Practice:Viewing the 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

Interfaces 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 Models 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 Command Object

The ADO Recordset Object

Lesson Summary

Lesson 3:Using the Data Environment

The Data Environment Designer

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

Establishing a Connection

Lesson 1:Managing Connections to a Data Source

Defining the ADO Connection Object

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 Navigation Methods

Practice:Navigating an ADO Recordset

Lesson Summary

Lesson 4:Modifying Records

Modifying Records with SQL statements

Modifying Records in a Recordset

Lesson Summary

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 and 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 Microsoft 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

About This Chapter

Before You Begin

Chapter 10:Implementing Security in the Enterprise

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

Lesson Summary

Comparison of SQL Server Security Modes

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 Clireg32.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 Handling

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 Component Debugging Limitations

Lesson Summary

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 Control

Appendix D:Creating Internet Applications

Appendix E:Preparing a Distributed Application for Deployment

Glossary

Index