Sams Teach Yourself Ado 2.5 in 21 Days

by Wille, Christoph; Kollier, Christian

• ISBN13: 9780672318733
• ISBN10: 0672318733
• Format: Paperback
• Copyright: 2000-01-01
• Publisher: Sams

Summary

Sams Teach Yourself ADO 2.5 in 21 Days teaches you how to build distributed database applications using today's latest technologies. Step-by-step tutorials and real-world examples illustrate how ADO enables programmers to access data in the most optimal manner. This book's coverage includes basic implementation of ADO 2.5 (i.e., data manipulation, working with recordsets, using stored procedures), advanced techniques (i.e., how to work asynchronously, data shaping, building applications, database management), and using ADO in a distributed environment (i.e., designing COM+ apps, the in-memory database, disconnecting data, using remote data service, debugging and tuning).

Table of Contents

Introduction	1	(6)
Week 1 At a Glance	7	(204)
Basic Knowledge About ADO	5	(20)
Retrieving Data Using ADO	25	(42)
Fail-Safe Inserting of Data	67	(34)
Updating and Deleting Database Data	101	(26)
Filtering and Sorting Resultsets	127	(26)
Working with Large Recordsets	153	(26)
Implementing Application Logic in Stored Procedures	179	(32)
Week 1 In Review	209	(2)
Week 2 At a Glance	211	(210)
Enrolling in Transactions	213	(20)
Working Asynchronously with ADO Events	233	(40)
Shaping Your Data into Hierarchical Recordsets	273	(26)
Analyzing Businesses with OLAP	299	(30)
Building Applications with ADO MD	329	(30)
Accessing Non-Relational Data	359	(32)
Managing Your Database with ADOX	391	(30)
Week 2 In Review	419	(2)
Week 3 At a Glance	421	(206)
Creating Scalable Solutions with COM+	423	(26)
Working with Disconnected Recordsets	449	(50)
Remoting Data Using RDS	499	(32)
Creating RDS Business Objects	531	(24)
ADO and XML Integration	555	(22)
Securing Your ADO/RDS Environment	577	(18)
Tuning and Debugging ADO Applications	595	(32)
Week 3 In Review	625	(2)
Appendixes	627	(66)
Appendix A Answers	627	(50)
B Technologies, Features, and Release Packages of MDAC and ADO	677	(6)
C OLE DB Providers and Services for ADO	683	(4)
D ADO Programming Quick-Reference	687	(6)
Index	693