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

✍ Scribed by William R. Vaughn (auth.)

• Publisher: Apress
• Year: 2002
• Tongue: English
• Leaves: 782
• Edition: 2
• Category: Library

✦ Synopsis

ADO.NET and ADO Examples and Best Practices for VB Programmers, Second Edition brings the popular first edition up to date with fresh insights and tips on COM-based ADOand adds a voluminous section on the new ADO.NET technology. Written specifically for COM-based ADO developers retooling for ADO.NET, this is a developer's book, packed with practical advice on how to make code run faster, yet be easier to write and understand.

Veteran author William Vaughn guides you through the data access maze with working examples and numerous discussions of what works and what doesn't. Derived from years of experience working with data access developers, Vaughn's Best Practices are a set of techniques proven to drastically reduce overhead, problems, and confusion—for the developer, the system, and the entire team. While some are quite simple to implement, others require considerable knowledge and forethought to enable.

✦ Table of Contents

Front Matter....Pages i-xx
Front Matter....Pages 1-1
Working with ADO....Pages 3-14
Introduction to ADO....Pages 15-21
Creating ADO Objects....Pages 23-28
Getting Connected....Pages 29-79
ADO Command Strategies....Pages 81-138
Recordset Strategies....Pages 139-223
Manipulating Your Recordset....Pages 225-292
Understanding Record and Stream Objects....Pages 293-299
Passing Resultsets Between Layers....Pages 301-343
Getting Your Data into Shape....Pages 345-360
Data Access Tips and Techniques....Pages 361-378
ADO and the Visual Database Tools....Pages 379-397
Front Matter....Pages 399-399
Introducing ADO.NET....Pages 401-434
ADO.NET—Getting Connected....Pages 435-472
ADO.NET Command Strategies....Pages 473-528
ADO.NET DataReader Strategies....Pages 529-543
Using the DataTable and DataSet....Pages 545-583
Filtering, Sorting, and Finding....Pages 585-606
ADO.NET Update Strategies....Pages 607-666
ADO.NET Constraint Strategies....Pages 667-684
Front Matter....Pages 399-399
ADO.NET Error Management Strategies....Pages 685-696
ADO.NET and XML....Pages 697-727
Back Matter....Pages 729-772

✦ Subjects

Software Engineering/Programming and Operating Systems; Coding and Information Theory