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
鄂公網(wǎng)安備 42010302001612號 