Visual Basic Developer's Guide to ADO

Name: Visual Basic Developer's Guide to ADO
Availability: OutOfStock
ISBN: 9780782125566

ISBN-10: 0782125565

ISBN-13: 9780782125566

Edition: 3rd 1999

Authors: Mike Gunderloy

List price: $39.99

30 day, 100% satisfaction guarantee!

Out of stock

We're sorry. This item is currently unavailable.

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

ADO (Active X Data Objects) is Microsoft's new standard for universal data access and is an essential part of their strategy for enterprise application development. This book provides a guide to ADO for professionsal Visual Basic developers.

Book details

List price: $39.99
Edition: 3rd
Copyright year: 1999
Publisher: John Wiley & Sons, Incorporated
Binding: Paperback
Pages: 480
Size: 7.75" wide x 9.25" long x 1.25" tall
Weight: 2.068
Language: English



Introduction



Overview of ADO and Visual Basic


A Brief History of ADO


What's New in ADO 2.5


ADO as a System Component


Record and Stream Objects


URLs as Connection Strings


Provider-Supplied Fields


New OLE DB Providers


What's New in VB 6 Data Access


ADO


Data Environment and Data Report


Enhanced Data Binding


User-Created Data Sources


New Controls


Enhanced Data Wizards


Getting ADO


MDAC


Windows 2000


MDAC SDK



Understanding Data Access Architecture


ADO and OLE DB


OLE DB Architecture


What ADO Brings to OLE DB


Available OLE DB Components


ADO Extensibility


The Big Picture


Other Data Access Libraries


ODBC


DAO


RDO


Choosing a Data Access Library



The ADO Object Model


The ADO Object Hierarchy


The Connection Object


Methods, Properties, and Events


Using the Connection Object


The Command Object


Methods, Properties, and Events


Using the Command Object


The Recordset Object


Methods and Properties


Using Recordset Objects


The Parameter Object


Methods and Properties


Using Parameter Objects


The Field Object


Methods and Properties


Using Field Objects


The Record Object


Methods and Properties


Using Record Objects


The Stream Object


Methods and Properties


Using Stream Objects


The Error Object


Methods and Properties


Using Error Objects


The Property Object


ADO Extensions


ADOX


ADO MD



Exploring Data from Visual Basic


Using the Data View Window


Connecting to Data


Creating and Using Database Diagrams


Working with Tables


Using Triggers


Using the Query Designer


Designing a Query


The Diagram Pane


The Grid Pane


The SQL Pane


The Results Pane


Creating and Debugging Stored Procedures


Viewing Stored Procedure Definitions and Resultsets


The T-SQL Debugger



Using Bound Controls to Present ADO Data


Using the ADO Data Control


Connecting to Data


ADO Data Control Properties


Binding Simple Controls


A Simple Data-Aware Form


DataList and DataCombo


DataGrid


The Data Form Wizard


Single Record Forms


Grid Forms


Master/Detail Forms


Programming the ADO Data Control


The Refresh Method


Events


The Hierarchical FlexGrid Control


A Sample Hierarchical FlexGrid Form



Rapid Data Access with the Data Environment


Creating Connections


Using Command Objects in the Data Environment


Creating Command Objects


Working with Command Objects


Command Object Hierarchies


Data Environment Options and Operations


General Options


Associating Control Types with Data


Miscellaneous Data Environment Options


Binding Forms to the Data Environment


Creating Bound Forms


Using Drag-and-Drop


Using Parameterized Stored Procedures


Using ADO Events in the Data Environment


Data Environment Events


Connection Events


Recordset Events


Using the Data Environment in Code



Creating Data Reports


Anatomy of a Data Report


Creating Data Reports


Using Drag-and-Drop from the Data Environment


Using the Data Report Toolbox


Using Calculated Fields


Special Header and Footer Controls


Properties on Data Reports


Data Report Properties


Section Properties


Control Properties


Summarizing Data on Data Reports


Using the Function Control


Using Grouping and Aggregate Hierarchies


Using Data Reports


Print Preview


Print


Export


Data Reports in Code


Data Report Events


Binding Data Reports Directly



Fine-Tuning ADO through Visual Basic Code


Basic Operations


Connecting to Data Sources


Connection Strings


Running Stored Procedures


Retrieving Data


Finding and Sorting Data


Sorting Recordsets


Updating, Adding, and Deleting Data


The Supports Method


Working with Persisted Recordsets


Saving a Recordset


Loading a Saved Recordset


Advanced Operations


Asynchronous Operations and ADO Events


Batch Updates and Conflicts



Creating and Using Visual Basic Data Consumers


What Is a Data Consumer?


Data-Aware Classes


Simple Binding with a Class


Complex Binding with a Class


Data-Aware UserControls


Simple Binding with a UserControl


Multiple Simple Bindings in the Same UserControl


Complex Binding with a UserControl


Using the DataRepeater Control



Data Shaping


What Is Data Shaping?


Hierarchical Recordsets


The Data Shaping Service


Types of Hierarchical Recordsets


Relation Hierarchies


Parameterized Hierarchies


Grouping Hierarchies


The SHAPE Statement


Syntax of SHAPE


Examples of the SHAPE Statement


Synchronizing Recordsets



Fast Internet Applications with ADO and Visual Basic


DHTML and ADO


What Is DHTML?


The Document Object Model


A Simple DHTML Application


Using ADO with DHTML


Remote Data Service


Examining RDS


Using a Disconnected Recordset


Using the RDS.DataControl Object


Using the RDS.DataSpace Object


Invoking Business Objects on the Server



Using ADO MD to Summarize Data


Basics of Multidimensional Data


Understanding Multidimensional Data


Introduction to Microsoft OLAP Server


Cubes, Dimensions, and Measures


MOLAP, ROLAP, and HOLAP


Microsoft OLAP Manager


ADO MD Objects


Schema Objects


Data Objects


Additional ADO MD Techniques


Using OpenSchema to List Objects


Opening a Recordset from a Cellset



Creating Data Sources with Visual Basic


Overview of Creating Data Sources


Choosing a Plan of Attack


Creating an ActiveX Data Source Control


Creating the User Interface


Handling Properties


Handling Data


A More Complex Example


Creating an OLE DB Provider


Implementing OLE DB Simple Provider


Using the OLE DB Simple Provider



A SQL Language Primer


The SELECT Statement


The SELECT Clause


The FROM Clause


The WHERE Clause


The GROUP BY Clause


The HAVING Clause


The ORDER BY Clause


Data Modification Statements


The DELETE Statement


The INSERT Statement


The UPDATE Statement


Other SQL Statements