Serious ADO: Universal Data Access with Visual Basic

✍ Scribed by Rob Macdonald (auth.)

• Publisher: Apress
• Year: 2000
• Tongue: English
• Leaves: 614
• Edition: 1
• Category: Library

✦ Synopsis

From seasoned developer and trainer Rob Macdonald comes Serious ADO: Universal Data Access with Visual Basic, which teaches experienced Visual Basic developers how to make the most of ADO, Microsoft's flagship product for database access. Serious ADO covers the full range of uses for ADO, from basic use of the ADO technology to specialized topics and advanced techniques that will benefit even the most experienced developers.

The first part of the book provides thorough coverage of ADO's components and what they can do. Along the way, Macdonald offers real-world code examples along with complete explanations of exactly what is occurring at each stage of the development process. This part also covers some of the key concepts upon which ADO programming is based, such as locking and transactions, connection pooling, marshalling, and Inter Process Communication, among others.

The second part of the book addresses the use of ADO in real-world development scenarios. Here, Macdonald demonstrates advanced user interface creation, including new ways to control the binding process. You'll also learn how to use Microsoft Transaction Server of COM+ applications to create transactional component-based systems.

✦ Table of Contents

Front Matter....Pages i-xvi
ADO’s Big Idea....Pages 1-7
Front Matter....Pages 9-9
ADO Unplugged....Pages 11-62
Recordsets with SQL Data Sources....Pages 63-125
Explicit Connections....Pages 127-162
Explicit Commands....Pages 163-191
The ADO Event Model and Asynchronous Processing....Pages 193-225
Disconnected Recordsets....Pages 227-286
Recordset Recursion and Data Shaping....Pages 287-326
Working with Documents—Records and Streams....Pages 327-359
The ADO Data Definition Language and Security Model (ADOX)....Pages 361-380
Creating Simple Providers....Pages 381-418
Front Matter....Pages 419-419
Binding and Data-aware Objects....Pages 421-449
The Data Environment....Pages 451-479
ADO, DNA, MTS, and COM+....Pages 481-511
RDS and DHTML....Pages 513-541
Multidimensional ADO (ADOMD)....Pages 543-579
Back Matter....Pages 581-616

✦ Subjects

Software Engineering/Programming and Operating Systems