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

1. Front Matter

   Pages i-xx

   PDF

2. ADO Classic

   1. Front Matter

      Pages 1-1

      PDF

   2. Working with ADO

      • William R. Vaughn

      Pages 3-14

   3. Introduction to ADO

      • William R. Vaughn

      Pages 15-21

   4. Creating ADO Objects

      • William R. Vaughn

      Pages 23-28

   5. Getting Connected

      • William R. Vaughn

      Pages 29-79

   6. ADO Command Strategies

      • William R. Vaughn

      Pages 81-138

   7. Recordset Strategies

      • William R. Vaughn

      Pages 139-223

   8. Manipulating Your Recordset

      • William R. Vaughn

      Pages 225-292

   9. Understanding Record and Stream Objects

      • William R. Vaughn

      Pages 293-299

   10. Passing Resultsets Between Layers

       • William R. Vaughn

       Pages 301-343

   11. Getting Your Data into Shape

       • William R. Vaughn

       Pages 345-360

   12. Data Access Tips and Techniques

       • William R. Vaughn

       Pages 361-378

   13. ADO and the Visual Database Tools

       • William R. Vaughn

       Pages 379-397

3. ADO.NET and the .NET Framework

   1. Front Matter

      Pages 399-399

      PDF

   2. Introducing ADO.NET

      • William R. Vaughn

      Pages 401-434

   3. ADO.NET—Getting Connected

      • William R. Vaughn

      Pages 435-472

   4. ADO.NET Command Strategies

      • William R. Vaughn

      Pages 473-528

   5. ADO.NET DataReader Strategies

      • William R. Vaughn

      Pages 529-543

   6. Using the DataTable and DataSet

      • William R. Vaughn

      Pages 545-583

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.

• .NET
• .NET framework
• ADO
• ADO.NET
• C programming language
• Fusion
• Visual Basic
• XML
• code
• constraint
• design
• filtering
• interfaces
• language
• object

William (Bill) Vaughn is an industry-recognized author, mentor and subject-matter expert. He's been in the computer industry for over 30 years he's worked with mainframe, minicomputer, and personal computer systems as a developer, manager, trainer, marketer, support person, and writer. After 14 years at Microsoft, Bill stepped away to work on his books and training seminars. His area of specialization is focused on data access and especially Visual Basic and SQL Server. He's written six editions of The Hitchhiker's Guide to Visual Basic and SQL Server (Microsoft Press) and two editions of ADO.NET and ADO Examples and Best Practices for Visual Basic Programmers (Apress). There's even a C# version: ADO.NET Examples and Best Practices for C# Programmers (Apress). Bill is a top-rated speaker and frequents conferences all over the world, including VSLive, Developer Connections, and PASS (Professional Association for SQL Server). He's also written a wealth of articles for magazines such as SQL Server Magazine, Visual Basic Programmer's Journal, .NET Magazine, and many others. Bill is working on content focusing on the .NET Compact Framework and SQL Server CE, as well as the next version of SQL Server. He's available for consulting or custom training.

Policies and ethics