+612 9045 4394
ADO - ActiveX Data Objects : Covers 2.6 - Jason Roff

ADO - ActiveX Data Objects

Covers 2.6

Paperback Published: 12th July 2001
ISBN: 9781565924154
Number Of Pages: 624

Share This Book:


RRP $72.00
Ships in 15 business days

Getting data across platforms and formats is a cornerstone of present-day applications development. ADO: ActiveX Data Objects is both an introduction and a complete reference to ADO (ActiveX Data Objects), Microsoft's universal data access solution. You'll learn how to easily access data in multiple formats--such as email messages, Access databases, Word documents, and SQL databases--even on different platforms, without spending extra time learning every last detail about each format.

Author Jason Roff shows by example how to use ADO with your programming language of choice to save programming time, so you can concentrate on the content and quality of your application rather than the nitty-gritty of specific data formats.

ADO: ActiveX Data Objects includes:

  • Chapters dedicated to the Connection, Recordset, Field, and Command objects and the Properties collection
  • A complete, detailed reference listing every ADO object, method, property, and event, in convenient alphabetical order
  • Chapters on ADO architecture, data shaping, the ADO Event Model
  • An appendix containing enumeration tables used by ADO objects and collections, listed alphabetically
  • Brief introductions to RDS, ADO.NET, and SQL

ADO: ActiveX Data Objects is a versatile one-stop guide to both the theory and practice of programming with ADO through Version 2.6. The thorough reference section and topic-specific chapters will help you find quick answers about the details of objects, collections, methods, and properties of ADO. And the abundance of practical code examples will give you a good grasp of how to use ADO's strong points most effectively.

Prefacep. ix
Learning ADOp. 1
Introduction to ADOp. 3
ADO in Context: Universal Data Accessp. 3
ADO and COM: Language Independencep. 13
When to Use ADOp. 15
Summaryp. 18
The ADO Architecturep. 19
An Overview of the ADO Architecturep. 19
ADO Componentsp. 21
Summaryp. 29
Accessing ADO with Various Languagesp. 31
Accessing ADO with Visual Basicp. 31
Accessing ADO with Visual C++p. 36
Accessing ADO with Visual J++p. 40
Accessing ADO with VBScriptp. 43
Accessing ADO with JScriptp. 47
Summaryp. 50
The Connection Objectp. 51
Opening and Closing a Connection: Implicit Versus Explicitp. 51
Configuring Connectionsp. 54
Choosing a Data Providerp. 70
Executing Commandsp. 73
Managing Multiple Transactionsp. 77
Determining the Layout of Your Data Sourcep. 85
Summaryp. 91
The Recordset Objectp. 92
Cursors: Viewing a Recordsetp. 92
Working with Recordsetsp. 101
Navigating a Recordsetp. 115
Working with Recordsp. 128
Lock Types: Managing Access to a Recordsetp. 135
Summaryp. 141
Fieldsp. 143
The Fields Collection Objectp. 143
Field Specificsp. 145
Determining Field Object Functionalityp. 155
Summaryp. 157
The Command Objectp. 158
Specifying Commandsp. 158
Executing Commandsp. 163
Parametersp. 167
The Parameters Projectp. 172
Asynchronous Executionp. 177
Summaryp. 182
The ADO Event Modelp. 183
Introduction to Eventsp. 183
The ConnectionEvent Familyp. 185
The RecordsetEvent Familyp. 199
Canceling Operationsp. 212
Turning Events Offp. 213
Summaryp. 214
Data Shapingp. 216
An Introduction to Data Shapingp. 216
The Microsoft Data Shaping Servicep. 217
Shaping Commandsp. 218
Example: Accessing Shaped Recordsetsp. 227
Summaryp. 235
Records and Streamsp. 236
The Record Objectp. 236
The Stream Objectp. 252
Summaryp. 259
Remote Data Servicesp. 261
RDS Object Modelp. 261
An Example in RDSp. 272
More Information About RDSp. 274
Summaryp. 274
The Microsoft .NET Framework and ADO.NETp. 275
The Microsoft .NET Frameworkp. 275
ADO.NETp. 277
ADO.NET Featuresp. 278
Summaryp. 280
Reference Sectionp. 281
ADO API Referencep. 283
Finding the Reference Pagep. 283
Using the Reference Pagesp. 288
Appendixesp. 459
Introduction to SQLp. 461
The Properties Collectionp. 481
ADO Errorsp. 500
The ADO Data Controlp. 516
Enumeration Tablesp. 536
Indexp. 585
Table of Contents provided by Syndetics. All Rights Reserved.

ISBN: 9781565924154
ISBN-10: 1565924150
Audience: Professional
Format: Paperback
Language: English
Number Of Pages: 624
Published: 12th July 2001
Publisher: John Wiley & Sons Publishers
Country of Publication: US
Dimensions (cm): 23.4 x 18.0  x 3.24
Weight (kg): 1.06