本书是《微软指定MCSD教材(影印版)》丛书中的一本,讲述Visual Basic 6.0分布式应用程序开发技巧,内容包括系统安装与配置、数据模型设计、用户界面、COM组件、ADO、MTS、安全性等。本书还可指导您准备MCP 70-175考试(微软认证解决方案开发人员证书的一门核心考试)。\r\n 本书由微软公司专家编写,技术深入,权威性强,可作为Visual Basic 6.0中高级开发人员和MCP考试应试者的参考书。\r\n
About This Book\r\n\r\nIntended Audience\r\nPrerequisites\r\nGeting Started\r\nHardware Requirements\r\nSoftware Requirements\r\nCourse Overview\r\nFeatures of This Book\r\nConventions Used in This Book\r\nAbout The CD-ROM\r\nUsing this Book to Prepare for Cervification\r\nWhere to Find Specific Skills in This Book\r\nThe Microsoft Certified Professional Program\r\nMicrosoft Certification Benefits\r\nTechnical Support\r\nAbout the Authors\r\n\r\nChapter 1:Application Design Concepts\r\n\r\nAbout This Chapter\r\nBefore You Begin\r\nLesson 1:Planning a Distributed Solution\r\nOverview of Microsoft Solutions Framework\r\nThe Solutions Design Model\r\nSoftware Requirements\r\nMultiple Developer Tools\r\nPractice:Adding Visual SourceSafe to Visual Basic\r\nLesson 2:Selecting an Application Architecture\r\nUnderstanding Application Structure\r\nDeveloping a Distributed Application\r\nLesson Summary\r\nLesson 3:Using Visual Database Tools\r\nUsing Visual Database Tools with Visual Studio\r\nDeriving Physical Design Using Visual Database Tools\r\nPractice:Tour of the SQL Server Pubs database\r\nLesson Summary\r\nSummary\r\nLab:Using Visual Component Manager\r\nReview\r\n\r\nChapter 2:Creating the User Interface\r\n\r\nAbout This Chapter\r\nBefore You Begin\r\nLesson 1:Overview of User Interface Elements\r\nControls\r\nSetting Properties\r\nManaging Events\r\nStandard Form Events\r\nUsing Collections\r\nPractice:Using the Collection Object’s Add Method\r\nLesson Summary\r\nLesson 2:Navigation and Validation\r\nDeveloping Navigation\r\nValidating Data\r\nLesson Summary\r\nSummary\r\nLab:Creating a User Interface Dynamically\r\nExercise 1:Creating the User Interface\r\nExercise 2:Validating User Input\r\nExercise 3:Adding and Coding a Menu Bar\r\nExercise 4:Dynamically Adding Controls\r\nReview\r\n\r\nChapter 3:Creating COM DLLs with Visual Basic\r\n\r\nAbout This Chapter\r\nBefore You Begin\r\nLesson 1:Creating Class Modules\r\nCreating Properties,Methods,and Events\r\nEvents\r\nCall-Back Methods\r\nEnumerations\r\nPractice:Using the Class Builder Utility\r\nLesson Summary\r\nLesson 2:Using Class Modules\r\nUsing the Object Browser\r\nPractice:Viewing thd CFile Class\r\nInstantiating a Class\r\nPractice:Using a Component’s Properties,Methods,and Events\r\nLesson Summary\r\nLesson 3:Creating COM DLLs and EXEs\r\nActiveX Project Templates\r\nSetting ActiveX DLL Project Properties\r\nSetting Class Properties in a Component\r\nRegistering and Unregistering Components\r\nTesting and Debugging Components\r\nPractice:Using a Project Group to Test a COM DLL\r\nLesson Summary\r\nSummary\r\nLab:Creating a COM DLL\r\nReview\r\n\r\nChapter 4:Advanced COM Programming with Visual Basic 6.0\r\n\r\nAbout This Chapter\r\nBefore You Begin\r\nLesson 1:Creating Custom Interfaces\r\nInterface-Based Programming\r\nInterface and Visual Basic\r\nPractice:Viewing a Type Library with the OLE View Tool\r\nCreating Your Own Interfaces\r\nPolymorphism\r\nVersion Compatibility\r\nLesson Summary\r\nLesson 2:Developing a Custom Object Model\r\nCustom Business Objects\r\nCreating an Object Model\r\nCollection Classes\r\nVisual Basic Object Modeling Tools\r\nPractice:Creating Object Moedls with the Class Builder Utility\r\nLesson Summary\r\nSummary\r\nLab:Advanced COM Programming with Visual Basic\r\nExercise 1:Creating the IEmployee Interface\r\nExercise 2:Implementing the IEmployee Interface\r\nExercise 3:Testing the PayRoll Component\r\nReview\r\n\r\nChapter 5:Introducing ActiveX Data Objects\r\n\r\nAbout This Chapter\r\nBefore You Begin\r\nLesson 1:Overview of Universal Data Access\r\nOverview of Universal Data Access\r\nActiveX Data Objects\r\nLesson Summary\r\nLesson 2:Introduction to the ADO Object Model\r\nCreating ADO Objects\r\nThe ADO Connection Object\r\nThe ADO Connection Object\r\nThe ADO Recordset Object\r\nLesson Summary\r\nLesson 3:Using the Data Environment\r\nThe Data Environment Environment\r\nPractice:Data Binding Using a Data Environment\r\nLesson Summary\r\nSummary\r\nLab:Using the Data Environment and ADO\r\nReview\r\n\r\nChapter 6:Accessing Data with ActiveX Data Objects\r\n\r\nAbout This Chapter\r\nBefore You Begin\r\nLesson 1:Managing Connections to a Data Source\r\nDefineng the ADO Connection Object\r\nEstablishing a Connection\r\nPractice:Programmatically Creating a Connection\r\nUsing the ADO Command Object\r\nLesson Summary\r\nLesson 2:Returning Records from a Data Source\r\nUsing the ADO Recordset Object\r\nAccessing Records in a Recordset\r\nBinding Controls to ADO Recordsets\r\nCreating Multiple Recordsets\r\nCreating Programmatic Recordsets\r\nLesson Summary\r\nLesson 3:Navigating Records\r\nADO Navigation Properties\r\nADO Navagation Methods\r\nPractice:Navigating an ADO Recordset\r\nLesson Summary\r\nLesson 4:Modifying Records\r\nModifying Records with SQL stateiments\r\nModifying Records in a Recordset\r\nLesson Summary\r\nLab:Accessing Data Using ADO Objects\r\nExercise 1:Creating the COM Component that Uses ADO\r\nExercise 2:Creating the Client\r\nReview\r\n\r\nChapter 7:Advanced Database Topics\r\n\r\nAbout This Chapter\r\nBefore You Begin\r\nLesson 1:Introduction to Transactions\r\nDefinition of a Transaction\r\nTransactions and ADO\r\nTypes of Transactions\r\nCoding Efficient Transactions\r\nTransact-SQL\r\nLesson Summary\r\nLesson 2:Using Disconnected Recordsets\r\nSpecifying the CursorLocation Property\r\nDisconnecting from a Data Source\r\nReconnecting to a Data Source\r\nPractice:Working With Disconnected Recordsets\r\nLesson Summary\r\nLesson 3:Asynchronous Operations\r\nConnecting Asynchronously to a Data Source\r\nUsing ADO Events\r\nAsynchronously Executing a Command\r\nAsynchronously Fetching Results\r\nLesson Summary\r\nSummary\r\nLab:Using Disconnected Recordsets\r\nReview\r\n\r\nChapter 8:Using Stored Procedures\r\n\r\nAbout This Chapter\r\nBefore You Begin\r\nLesson 1:Overview of Stored Procedures\r\nAdvantages of Using Stored Procedures\r\nStored Procedures in a Two-Tier Model\r\nStored Procedures in an N-Tier Model\r\nStored Procedures and the Command Object\r\nPractice:Calling a Stored Procedure\r\nLesson Summary\r\nLesson 2:Using Stored Procedures\r\nCreating Simple Stored Procedures\r\nUsing Parameters in Stored Procedures\r\nGenerating Multiple Recordsets\r\nImplementing Transactions\r\nDebugging Transact-SQL\r\nLesson Summary\r\nSummary\r\nLab:Creating adn Calling a Stored Procedure\r\nExercise 1:Creating a Data Access Component\r\nExercise 2:Creating the Front-End Application\r\nReview\r\n\r\nChapter 9:Using Microsoft Transaction Server\r\n\r\nAbout This Chapter\r\nBefore You Begin\r\nLesson 1:Overview of Microsot Transaction Server\r\nDeveloping N-tier Applications with MTS\r\nMTS Services\r\nAn MTS Application Example\r\nLesson Summary\r\nLesson 2:Installing and Configuring Microsoft Transaction Server\r\nMTS System Requirements\r\nConfiguring Your MTS Server\r\nConfiguring Your Development Computer\r\nLesson Summary\r\nLesson 3:Creating Solutions Using Microsoft Transaction Server\r\nDesigning MTS Components\r\nCreating MTS Components\r\nUsing Transactions in MTS Components\r\nDeploying MTS Components\r\nLesson Summary\r\nSummary\r\nLab:Creating and Deploying MTS Components\r\nExercise 1:Setting up the Chateau Database\r\nExercise 2:Creating the Client Application\r\nExercise 3:Creating the Chateau COM DLL\r\nExercise 4:Deploying Your COM DLL with MTS\r\nReview\r\n\r\nChapter 10:Implementing Security in the Enterprise\r\n\r\nAbout This Chapter\r\nBefore You Begin\r\nLesson 1:Overview of Security\r\nPrinciples of Security\r\nWindows NT Security Model\r\nEnterprise Application Security\r\nLesson Summary\r\nLesson 2:Implementing SQL Server Security\r\nOverview of SQL Server Security\r\nComparison of SQL Server Security Modes\r\nLesson Summary\r\nLesson 3:Implementing Security in Microsoft Transaction Server\r\nUnderstanding Roles and Security\r\nSetting Package Properties\r\nUsing Programmatic Security\r\nLesson Summary\r\nLesson 4:Implementing COM Security Using DCOMCNFG\r\nOverview of Distributed COM\r\nDeploying a COM EXE\r\nCreating Remote Server Files\r\nRegistering a Remote Component on a Client Computer\r\nPractice:Registering a Component with Clireg 32.exe\r\nLesson Summary\r\nSummary\r\nLab:Using Programmatic Security in an MTS Component\r\nExercise 1:Adding a Role to your MTS Component\r\nExercise 2:Writing Code to Implement Programmatic Security\r\nReview\r\n\r\nChapter 11:Debugging and Error Handing\r\n\r\nAbout This Chapter\r\nBefore You Begin\r\nLesson 1:Handling Errors in an Application\r\nUsing Visual Basic Debugging Tools\r\nCreating Error Handlers\r\nLesson Summary\r\nLesson 2:Testing and Debugging Middle-Tier Components\r\nTesting Code Components\r\nDebugging MTS Components\r\nHandling Errors in MTS Components\r\nMTS Components Debugging Limitations\r\nLesson Summary\r\nLab:Interactively Debugging an MTS Component\r\nExercise 1:\r\nReview\r\n\r\nAppendix A:Questions and Answers\r\n\r\nAppendix B:Creating ActiveX Controls\r\n\r\nAppendix C:Using the ADO Data Coutrol\r\n\r\nAppendix D:Creating Internet Applications\r\n\r\nAppendix E:Preparing a Distributed Application for Deployment\r\n\r\nGlossary\r\n\r\nIndex