ADO.NET and ADO Examples and Best Practices for VB Programmers

By: William R. Vaughn

Write A Review

Paperback | 5 February 2002 | Edition Number 2

At a Glance

Paperback
794 Pages

Edition Type
Revised

Dimensions(cm)
22.23 x 18.42 x 4.45

Paperback

RRP $99.00

$97.99

or 4 interest-free payments of $24.50 with

Ships in 10 to 15 business days

Visual Basic database developers are faced with a dizzying cornucopia of choices when it comes to data access paradigms. The onset of the new .NET technology forces developers to completely rethink their data access strategies. All at once, there is an entirely new language and a new set of data access interfaces to learn and to incorporate into their designs. The purpose of this book is to make the choice and implementation of the best of those technologies far easier. It does this through working examples and numerous discussions of what works and what doesn't. Vaughn's "Best Practices" are the techniques that developers need to know, because they cause the least amount of overhead, problems, and confusion - for the developer, the system, and the team. While some are quite simple to implement, other "Best Practices" require considerable thought and forethought to enable. This is a developer's book - full of hints, tips, and notes passed on from those who show the medals and scars of battles won and lost.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $79.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Computer Science Computer Programming & Software Development Programming & Scripting Languages Object-Oriented Programming or OOP Software Engineering

Foreword	p. iv
About the Author	p. xiii
Acknowledgments	p. xv
Introduction	p. xvii
ADO Classic	p. 1
Working with ADO	p. 3
Choosing the "Right" Version of ADO	p. 3
What's New in ADO 2.5?	p. 6
What's New in ADO 2.6?	p. 8
What's New in ADO 2.7?	p. 9
The ADO Component Checker	p. 9
Installing ADO	p. 10
Deploying ADO	p. 11
The .NET Framework Approach	p. 13
Getting More Help with ADO	p. 14
Introduction to ADO	p. 15
ADO and OLE DB	p. 15
The ADO Object Model	p. 18
Creating ADO Objects	p. 23
Instantiating ADO Objects	p. 23
Instantiating ADO Components in Visual Basic Script	p. 25
When Things Go Wrong	p. 27
Getting Connected	p. 29
The ADO Connection Object	p. 31
Using the Connection Object	p. 34
Managing Transactions	p. 74
ADO Command Strategies	p. 81
Inner Workings of the Command Object	p. 82
Building Command Objects	p. 86
Managing Command Objects	p. 124
Performance Considerations: Using Command Objects Wisely	p. 137
Recordset Strategies	p. 139
Introducing Recordsets	p. 139
Constructing Recordset Objects	p. 144
Working with Recordset Objects	p. 148
Manipulating Your Recordset	p. 225
Data Binding Your Recordset	p. 225
Understanding the State Property	p. 226
Fetching Techniques	p. 227
Sorting, Filtering, and Finding	p. 243
Disconnecting Recordsets	p. 248
Choosing Read-Only vs. Read-Write Recordsets	p. 249
Working with Field Objects	p. 249
Working with Stored Procedures	p. 261
Accessing Deprecated Recordsets	p. 287
Recordset Events	p. 289
Understanding Record and Stream Objects	p. 293
Introducing the ADO Record Object	p. 293
Introducing the Stream Object	p. 294
Passing Resultsets Between Layers	p. 301
Delivering Pizza with a Dump Truck	p. 302
Understanding Recordset Marshaling	p. 306
Passing Disconnected Recordsets	p. 312
Passing Strings and String Arrays	p. 318
Passing OUTPUT Parameters Instead of Rowsets	p. 321
Passing Variant Arrays	p. 324
Passing User-defined Structures	p. 326
Passing PropertyBags	p. 338
Passing XML	p. 341
Getting Your Data into Shape	p. 345
The Shape Provider	p. 346
Building a Simple Shape	p. 347
Why Not Use the Data Environment Designer?	p. 353
Analyzing the Impact	p. 356
Finding a Better Way	p. 357
The Impact of the "Just Enough" Approach	p. 359
Data Access Tips and Techniques	p. 361
Referencing Data on Other Servers	p. 361
TSOL Tips	p. 362
Performance-Tuning Stored Procedures	p. 365
SET NOCOUNT Using OLE DB Providers	p. 366
Granting Permissions	p. 367
More Recordset Secrets	p. 369
Working with the Grid Control	p. 374
Working with Strings	p. 375
Working with Graphics	p. 377
MDAC/ADO Setup Issues	p. 377
Hooking up Visual Basic/ADO Help	p. 378
ADO and the Visual Database Tools	p. 379
Using the Data View Window	p. 380
Using the Data Environment Designer	p. 386
Using ADO without the Data Environment Designer	p. 394
Using the Data Object Wizard	p. 395
ADO.NET and the .NET Framework	p. 399
Introducing ADO.NET	p. 401
How We Got Here	p. 401
ADO.NET--A New Beginning	p. 405
Understanding ADO.NET Infrastructure	p. 407
ADO.NET .NET Data Providers	p. 413
ADO.NET and Disconnected Data Structures	p. 418
The System.Data Namespace	p. 419
ADO.NET's Low-Level Data Stream	p. 432
ADO.NET--Getting Connected	p. 435
ADO.NET .NET Data Providers	p. 436
Creating ADO.NET Connection Objects	p. 438
Connecting via the SqlClient .NET Data Provider	p. 446
Managing Transactions	p. 453
Connecting with the Odbc .NET Data Provider	p. 454
Opening ADO.NET Connections in Code	p. 457
Using the IDE to Get Connected	p. 458
Closing Connections	p. 460
COM-based ADO as a .NET Data Provider	p. 468
ADO.NET Command Strategies	p. 473
Understanding ADO.NET Commands	p. 473
Binding to Resultset Columns	p. 524
ADO.NET DataReader Strategies	p. 529
Comparing ADOc with ADO.NET	p. 530
Understanding the DataReader	p. 532
Using the DataReader Get Methods to Retrieve Data	p. 539
Cleaning Up After your DataReader	p. 543
Using the DataTable and DataSet	p. 545
Understanding the DataSet and DataTable Structure	p. 547
Importing ADOc Recordsets	p. 555
Building DataTables	p. 559
Accessing DataTable Data	p. 567
Accessing DataSet Data	p. 581
Binding to DataSets	p. 582
Filtering, Sorting, and Finding	p. 585
Filtering and Sorting with the Select Method	p. 586
Working with the DataViewManager	p. 598
Using the Find Methods	p. 600
ADO.NET Update Strategies	p. 607
Changing Data--The Fundamentals	p. 608
Update Strategies	p. 622
Using Visual Studio to Generate Action Queries	p. 633
Retrieving Autonumber, Identity, or GUIDs	p. 641
Understanding the Update Methods	p. 645
Update Performance	p. 647
Updating the Authors Table--An Example	p. 649
Update Error Handling Strategies	p. 656
Handling Update Method Exceptions	p. 660
Executing Ad Hoc Queries to Perform Updates	p. 664
Merging and Transporting Data	p. 664
ADO.NET Constraint Strategies	p. 667
Understanding .NET Constraints	p. 667
How ADO.NET Implements Constraints	p. 669
Creating DataRelation Objects	p. 679
ADO.NET Error Management Strategies	p. 685
Structured Exception Handling	p. 686
Understanding Try/Catch	p. 686
Trapping Specific vs. General Exceptions	p. 690
The System.Data Exceptions	p. 690
Displaying the Error Message	p. 695
ADO.NET and XML	p. 697
XML Support in ADO.NET	p. 698
Standardizing on XML Formats	p. 699
Understanding XML and DataSet Objects	p. 700
Creating a Web Service as an XML Data Source	p. 710
Passing an Updated DataSet Back to a Web Service	p. 720
Creating Custom Error Handlers	p. 725
ADO.NET and SOAP	p. 726
Working with the Biblio Sample Database	p. 729
CompareCursorLocation Chart	p. 731
ADOc Dynamic Properties	p. 743
Index	p. 753
Table of Contents provided by Syndetics. All Rights Reserved.

ADO.NET and ADO Examples and Best Practices for VB Programmers

At a Glance

Paperback

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Object-Oriented Programming or OOP

Effective Modern C++

42 Specific Ways to Improve Your Use of C++11 And C++14

Design Patterns

Elements of Reusable Object-Oriented Software

Statistical Analysis with R For Dummies

For Dummies (Computer/Tech)

PHP, MySQL, & JavaScript All-In-One For Dummies

For Dummies

Head First Design Patterns

Building Extensible and Maintainable Object-Oriented Software 2nd Edition

Programming Rust

Fast, Safe Systems Development 2nd Edition

Object-Oriented and Classical Software Engineering - Global Edition

8th Edition

Concurrency in C# Cookbook

2nd Edition - Asynchronous, Parallel, and Multithreaded Programming

Head First Python

3rd Edition - A Learner's Guide to the Fundamentals of Python Programming, a Brain-Friendly Guide

Learning Python

Powerful Object-Oriented Programming

Getting Started with Arduino 4e

The Open Source Electronics Prototyping Platform

Head First Objects-Oriented Analysis and Design

The Best Introduction to Object Orientated Programming

Mastering Regular Expressions

OREILLY

C# Programming in easy steps

Master C# fundamentals!

Learning C# 3.0

OREILLY

Python in easy steps

In Easy Steps

Computer Science Why

Answers to Computer Science Questions They Don't Cover in Class

Computer Science Why

Answers to Computer Science Questions They Don't Cover in Class

C++ Primer

Refactoring 2ed

Improving the Design of Existing Code

Objects First with Java 6ed

A Practical Introduction Using BlueJ, Global Edition

The Rust Programming Language Workbook

Interactive Rustlings Exercises and Solutions

Taking Testing Seriously

The Rapid Software Testing Approach

97 Things Every Programmer Should Know

OREILLY

This product is categorised by