Microsoft Visual Basic6.0分布式应用程序开发 影印第2版PDF|Epub|txt|kindle电子书版本网盘下载

Microsoft Visual Basic6.0分布式应用程序开发 影印第2版PDF格式电子书版下载

注意：本站所有压缩包均有解压码： 点击下载压缩包解压工具

Chapter 1:Application Design Concepts1

About This Chapter1

Before You Begin1

Lesson 1:Planning a Distributed Solution2

Overview of Microsoft Solutions Framework2

The Solutions Design Model3

Software Requirements5

Practice:Adding Visual SourceSafe to Visual Basic9

Multiple Developer Tools9

Lesson Summary12

Lesson 2:Selecting an Application Architecture13

Understanding Application Structure13

Developing a Distributed Application17

Lesson Summary21

Lesson 3:Using Visual Database Tools22

Using Visual Database Tools with Visual Studio22

Practice:Tour of the SQL Server Pubs database25

Deriving Physical Design Using Visual Database Tools25

Lesson Summary27

Summary28

Lab:Using Visual Component Manager29

Review31

Chapter 2:Creating the User Interface33

About This Chapter33

Before You Begin33

Lesson 1:Overview of User Interface Elements34

Controls34

Setting Properties39

Managing Events41

Standard Form Events42

Using Collections44

Practice:Using the Collection Object s Add Method46

Lesson Summary48

Developing Navigation49

Lesson 2:Navigation and Validation49

Validating Data52

Lesson Summary54

Summary55

Lab:Creating a User Interface Dynamically56

Exercise 1:Creating the User Interface56

Exercise 2:Validating User Input59

Exercise 3:Adding and Coding a Menu Bar60

Exercise 4:Dynamically Adding Controls62

Review64

Chapter 3:Creating COM DLLs with Visual Basic65

About This Chapter65

Before You Begin65

Lesson 1:Creating Class Modules66

Creating Properties,Methods,and Events66

Call-Back Methods69

Events69

Enumerations70

Practice:Using the Class Builder Utility71

Lesson Summary76

Lesson 2:Using Class Modules77

Using the Object Browser77

Practice:Viewing the CFile Class77

Instantiating a Class78

Practice:Using a Component s Properties,Methods,and Events81

Lesson Summary83

Lesson 3:Creating COM DLLs and EXEs84

ActiveX Project Templates84

Setting ActiveX DLL Project Properties85

Setting Class Properties in a Component90

Registering and Unregistering Components93

Testing and Debugging Components96

Practice:Using a Project Group to Test a COM DLL96

Lesson Summary98

Summary100

Lab:Creating a COM DLL101

Review104

Chapter 4:Advanced COM Programming with Visual Basic 6.0105

About This Chapter105

Before You Begin105

Lesson 1:Creating Custom Interfaces106

Interface-Based Programming106

Interfaces and Visual Basic108

Practice:Viewing a Type Library with the OLE View Tool111

Creating Your Own Interfaces112

Polymorphism115

Version Compatibility117

Lesson Summary121

Lesson 2:Developing a Custom Object Model123

Custom Business Objects124

Creating an Object Model125

Collection Classes127

Visual Basic Object Modeling Tools128

Practice:Creating Object Models with the Class Builder Utility129

Lesson Summary131

Summary132

Lab:Advanced COM Programming with Visual Basic133

Exercise 1:Creating the IEmployee Interface133

Exercise 2:Implementing the IEmployee Interface134

Exercise 3:Testing the PayRoll Component136

Review141

Chapter 5:Introducing ActiveX Data Objects143

About This Chapter143

Before You Begin143

Lesson 1:Overview of Universal Data Access144

Overview of Universal Data Access144

ActiveX Data Objects147

Lesson Summary148

Lesson 2:Introduction to the ADO Object Model149

Creating ADO Objects149

The ADO Connection Object151

The ADO Command Object151

The ADO Recordset Object151

Lesson Summary153

Lesson 3:Using the Data Environment154

The Data Environment Designer154

Practice:Data Binding Using a Data Environment160

Lesson Summary165

Summary166

Lab:Using the Data Environment and ADO167

Review171

Chapter 6:Accessing Data with ActiveX Data Objects173

About This Chapter173

Before You Begin173

Establishing a Connection174

Lesson 1:Managing Connections to a Data Source174

Defining the ADO Connection Object174

Practice:Programmatically Creating a Connection177

Using the ADO Command Object178

Lesson Summary180

Lesson 2:Returning Records from a Data Source181

Using the ADO Recordset Object181

Accessing Records in a Recordset184

Binding Controls to ADO Recordsets185

Creating Multiple Recordsets185

Creating Programmatic Recordsets187

Lesson Summary189

Lesson 3:Navigating Records190

ADO Navigation Properties190

ADO Navigation Methods191

Practice:Navigating an ADO Recordset191

Lesson Summary195

Lesson 4:Modifying Records196

Modifying Records with SQL statements196

Modifying Records in a Recordset197

Lesson Summary198

Summary199

Lab:Accessing Data Using ADO Objects200

Exercise 1:Creating the COM Component that Uses ADO200

Exercise 2:Creating the Client202

Review204

Chapter 7:Advanced Database Topics205

About This Chapter205

Before You Begin205

Lesson 1:Introduction to Transactions206

Definition of a Transaction206

Transactions and ADO207

Types of Transactions208

Coding Efficient Transactions210

Transact-SQL212

Lesson Summary214

Lesson 2:Using Disconnected Recordsets215

Specifying the CursorLocation Property216

Disconnecting from a Data Source218

Reconnecting to a Data Source219

Practice:Working With Disconnected Recordsets221

Lesson Summary229

Lesson 3:Asynchronous Operations230

Connecting Asynchronously to a Data Source230

Using ADO Events232

Asynchronously Executing a Command234

Asynchronously Fetching Results236

Lesson Summary239

Summary240

Lab:Using Disconnected Recordsets241

Review243

Chapter 8:Using Stored Procedures245

About This Chapter245

Before You Begin245

Lesson 1:Overview of Stored Procedures246

Advantages of Using Stored Procedures246

Stored Procedures in a Two-Tier Model247

Stored Procedures in an N-Tier Model248

Stored Procedures and the Command Object250

Practice:Calling a Stored Procedure251

Lesson Summary254

Lesson 2:Using Stored Procedures255

Creating Simple Stored Procedures255

Using Parameters in Stored Procedures259

Generating Multiple Recordsets260

Implementing Transactions261

Debugging Transact-SQL261

Lesson Summary263

Summary264

Lab:Creating and Calling a Stored Procedure265

Exercise 1:Creating a Data Access Component265

Exercise 2:Creating the Front-End Application266

Review270

Chapter 9:Using Microsoft Transaction Server271

About This Chapter271

Before You Begin271

Lesson 1:Overview of Microsoft Transaction Server272

Developing N-tier Applications with MTS273

MTS Services274

An MTS Application Example279

Lesson Summary280

Lesson 2:Installing and Configuring Microsoft Transaction Server281

MTS System Requirements282

Configuring Your MTS Server283

Configuring Your Development Computer285

Lesson Summary288

Lesson 3:Creating Solutions Using Microsoft Transaction Server289

Designing MTS Components289

Creating MTS Components290

Using Transactions in MTS Components293

Deploying MTS Components296

Lesson Summary298

Summary299

Lab:Creating and Deploying MTS Components300

Exercise 1:Setting up the Chateau Database300

Exercise 2:Creating the Client Application302

Exercise 3:Creating the Chateau COM DLL303

Exercise 4:Deploying Your COM DLL with MTS307

Review309

About This Chapter311

Before You Begin311

Chapter 10:Implementing Security in the Enterprise311

Lesson 1:Overview of Security312

Principles of Security312

Windows NT Security Model313

Enterprise Application Security314

Lesson Summary318

Lesson 2:Implementing SQL Server Security319

Overview of SQL Server Security320

Lesson Summary324

Comparison of SQL Server Security Modes324

Lesson 3:Implementing Security in Microsoft Transaction Server325

Understanding Roles and Security325

Setting Package Properties326

Using Programmatic Security331

Lesson Summary332

Lesson 4:Implementing COM Security Using DCOMCNFG333

Overview of Distributed COM334

Deploying a COM EXE335

Creating Remote Server Files336

Registering a Remote Component on a Client Computer337

Practice:Registering a Component with Clireg32.exe338

Lesson Summary343

Summary344

Lab:Using Programmatic Security in an MTS Component345

Exercise 1:Adding a Role to your MTS Component345

Exercise 2:Writing Code to Implement Programmatic Security347

Review349

Chapter 11:Debugging and Error Handling351

About This Chapter351

Before You Begin351

Lesson 1:Handling Errors in an Application352

Using Visual Basic Debugging Tools352

Creating Error Handlers356

Lesson Summary360

Lesson 2:Testing and Debugging Middle-Tier Components361

Testing Code Components362

Debugging MTS Components363

Handling Errors in MTS Components364

MTS Component Debugging Limitations367

Lesson Summary369

Summary370

Lab:Interactively Debugging an MTS Component371

Exercise 1:371

Review375

Appendix A:Questions and Answers377

Appendix B:Creating ActiveX Controls393

Appendix C:Using the ADO Data Control407

Appendix D:Creating Internet Applications419

Appendix E:Preparing a Distributed Application for Deployment437

Glossary451

Index473