Sams Teach Yourself Windows DNA Programming in 21 Days (Sams Teach Yourself)

Sams Teach Yourself Windows® DNA Programming Microsoft® in 21Days......Page 2
Copyright © 2000 by Sams Publishing......Page 3
Contents at a Glance......Page 4
Contents......Page 6
Foreword......Page 16
About the Contributors......Page 18
About the Technical Editor......Page 19
Acknowledgments......Page 20
Tell Us What You Think!......Page 21
Introduction......Page 22
WEEK 1 At a Glance......Page 30
WEEK 1 DAY 1  Understanding Windows DNA......Page 32
Evolution in Application Design......Page 33
Exploring a Classic Three-Tier Architecture......Page 37
The Microsoft Commitment......Page 38
Focusing on Solutions, Not Infrastructure......Page 39
Investigating the Windows DNA Building Blocks......Page 41
Introduction to the Three-Tiered Windows DNA Model......Page 42
Multitiered Design Principles......Page 46
Exploring Components: The New Promise of Software Reusability......Page 47
Windows DNA and the Team Environment......Page 52
Summary......Page 54
Q&A......Page 55
Quiz......Page 56
WEEK 1 DAY 2  Building a Windows DNA Application......Page 58
Presentation Tier......Page 59
Client-Side Presentation......Page 61
Active Server Pages (ASPs)......Page 69
Data Tier......Page 74
Begin with Scalability in Mind......Page 75
Typical DNA Configurations......Page 79
The Future of DNA......Page 81
Summary......Page 82
Q&A......Page 83
Workshop......Page 84
WEEK 1 DAY 3 Architecting a Windows DNA Solution......Page 86
Performing Analysis......Page 87
Mapping the Solution to the DNA Architecture......Page 102
Development Frameworks......Page 108
Summary......Page 111
Workshop......Page 112
The Basics of Database Architecture......Page 114
Exploring SQL Basics......Page 120
Developing Table Relationships......Page 126
Summary......Page 127
Workshop......Page 128
WEEK 1 DAY 5 Putting Business Logic in the Data Tier......Page 132
Ensuring Data Integrity......Page 133
Stored Procedures......Page 135
Where Do You Implement Business Rules?......Page 144
Q&A......Page 145
Workshop......Page 146
WEEK 1 DAY 6 ActiveX Data Objects (ADO)......Page 150
Creating a Data Source Name (DSN)......Page 151
Comparing OLE DB and ODBC......Page 154
Exploring the ADO Object Model......Page 155
Using the Recordset Object......Page 157
Using the Connection Object......Page 163
Exploring the Command Object......Page 165
Calling Stored Procedures......Page 170
Exploring Other Data Stores......Page 174
Q&A......Page 175
Workshop......Page 176
WEEK 1 DAY 7 Database Transactions and the Distributed Transaction Coordinator......Page 178
Exploring Transactions......Page 179
Applying Transaction Rules......Page 180
Working with Database Transactions......Page 184
Applying Transactions to the SmallTownBank Application......Page 190
Distributed Transactions......Page 196
Microsoft Distributed Transaction Coordinator......Page 198
Increasing Transaction Performance......Page 204
Microsoft Transaction Server......Page 205
Q&A......Page 206
Workshop......Page 207
WEEK 1 In Review......Page 208
WEEK 2 At a Glance......Page 210
WEEK 2 DAY 8 Introduction to COM and MTS......Page 212
Component Object Model (COM)......Page 213
Microsoft Transaction Server (MTS)......Page 218
Putting COM Components into an MTS Package......Page 219
Using Role-Based Security......Page 224
Summary......Page 228
Workshop......Page 229
WEEK 2 DAY 9 Building COM Components in VB......Page 232
Getting Started with COM......Page 233
Importing Your Visual Modeler Components......Page 235
Using SourceSafe......Page 238
Developing Your Project......Page 241
Utilizing the Class Builder Add-In......Page 249
Reverse-Engineering Your Code Back into Visual Modeler......Page 252
Creating a Test Harness......Page 254
Testing Your Components......Page 255
Storing Your Finished Code in Microsoft Repository......Page 258
Workshop......Page 260
WEEK 2 DAY 10 Adding Transactional Support......Page 262
Adding Transactional Support to Your Components......Page 263
Working with State and Components......Page 273
Creating a Package and Installing Components into Transaction Server......Page 274
Monitoring Your Components as They Transact......Page 277
Raising Errors......Page 279
Handling Updates......Page 280
Considering Design......Page 281
Q&A......Page 282
Workshop......Page 283
WEEK 2 DAY 11 Interacting with the Database—ADO Revisited......Page 286
Best Practices for Working with Data......Page 287
Bringing Data into Your Data Tier Component......Page 292
Sending Data to Requesting Components......Page 298
Receiving Data Back from Another Component......Page 300
Sending Data Back to the Data Store......Page 303
Exploring Transactional Properties......Page 304
Handling Errors......Page 305
Summary......Page 306
Workshop......Page 307
WEEK 2 DAY 12 The Power of XML......Page 310
Microsoft’s Push to Be a Leader in XML......Page 311
Introducing Hierarchical Data Structures......Page 312
Exploring XML Syntax......Page 313
Exploring XML Elements......Page 315
XML Schemas and Namespaces......Page 316
Using the XML Document Object Model......Page 321
Working with XML......Page 329
Summary......Page 340
Q&A......Page 341
Workshop......Page 342
WEEK 2 DAY 13 The Future: COM+......Page 344
Activating Objects with Just-in-Time Activation......Page 345
Reusing Objects via Resource Pooling......Page 346
Queued Components......Page 347
Events......Page 350
Using Automatic Transactions......Page 352
Constructor Strings......Page 354
Configuring COM+ Application......Page 355
Summary......Page 359
Workshop......Page 360
WEEK 2 DAY 14 Best Practices and Other Services......Page 362
Asynchronous Communications—Working with Message Queues......Page 363
Integrating Legacy Systems with Host Integration Server......Page 368
Getting to Know BizTalk Server 2000......Page 369
The JumpStart Kit Architecture......Page 376
Exploring the Simple Object Application Protocol (SOAP)......Page 379
Exploring Application Center 2000 Server......Page 381
Visual Studio.NET......Page 382
Web Applications......Page 383
Summary......Page 387
Workshop......Page 388
WEEK 2 In Review......Page 390
WEEK 3 At a Glance......Page 392
WEEK 3 DAY 15 A Rich Native Windows Client......Page 394
Building a Rich Client......Page 395
Using WinSock to Connect to Business Objects......Page 396
Using DCOM to Connect to Business Objects......Page 404
Using Remote Data Services (RDS) to Connect to Business Objects......Page 407
Using the Windows Internet Components to Connect to Business Objects......Page 412
Advantages and Disadvantages of a Native Windows Client......Page 414
Summary......Page 415
Workshop......Page 416
WEEK 3 DAY 16 Using ActiveX Controls to Move Business Logic from the Server to the Client......Page 418
What Are ActiveX Controls?......Page 419
Deciding When to Use ActiveX Controls......Page 421
Using Visual Basic to Build ActiveX Controls......Page 422
Deploying Your Controls to the Internet......Page 433
Q&A......Page 438
Workshop......Page 439
WEEK 3 DAY 17 Using DHTML for the Presentation Tier......Page 440
Distributing the Presentation Layer......Page 441
Up and Running with JavaScript......Page 442
Benefiting from DHTML......Page 445
Scripting Compatibility Issues—Netscape Versus Internet Explorer......Page 448
Client-Side Versus Server-Side Scripting......Page 449
Interacting with DOM......Page 451
Allowing Events to Work for You......Page 458
Interacting with ActiveX Controls......Page 461
Q&A......Page 463
Workshop......Page 464
WEEK 3 DAY 18 Active Server Pages......Page 466
Introducing Server-Side Scripting......Page 467
Creating Active Server Pages (ASPs)......Page 470
Exploring Built-In Objects......Page 473
Using Includes Files......Page 492
Using Scripting Objects and Server Components......Page 493
Q&A......Page 498
Workshop......Page 499
HTML–The Basics......Page 502
Checking Browser Compatibility in ASP......Page 520
HTML—A Static Presentation Layer......Page 522
Summary......Page 524
Workshop......Page 525
WEEK 3 DAY 20 Office 2000 and Web Components......Page 528
Office Web Components......Page 529
Using the Controls in a Solution......Page 533
Summary......Page 550
Q&A......Page 551
Workshop......Page 552
WEEK 3 DAY 21 Implementing Digital Dashboards in Windows DNA Applications......Page 554
Digital Dashboards and Outlook 2000—An Information Management Container......Page 556
Building a Digital Dashboard......Page 558
Integrating Your Content with Outlook 2000......Page 562
Viewing Your Content with the Full Version of Internet Explorer......Page 565
Adding Functionality to Your Dashboard......Page 566
Summary......Page 578
Workshop......Page 579
WEEK 3 In Review......Page 582
APPENDIX A Answers to the Quiz and Exercise Questions......Page 584
INDEX......Page 622