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

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.

One ADO Classic.- 1 Working with ADO.- 2 Introduction to ADO.- 3 Creating ADO Objects.- 4 Getting Connected.- 5 ADO Command Strategies.- 6 Recordset Strategies.- 7 Manipulating Your Recordset.- 8 Understanding Record and Stream Objects.- 9 Passing Resultsets Between Layers.- 10 Getting Your Data into Shape.- 11 Data Access Tips and Techniques.- 12 ADO and the Visual Database Tools.- Two ADO.NET and the .NET Framework.- 13 Introducing ADO.NET.- 14 ADO.NET—Getting Connected.- 15 ADO.NET Command Strategies.- 16 ADO.NET DataReader Strategies.- 17 Using the DataTable and DataSet.- 18 Filtering, Sorting, and Finding.- 19 ADO.NET Update Strategies.- 20 ADO.NET Constraint Strategies.- 21 ADO.NET Error Management Strategies.- 22 ADO.NET and XML.- Appendix A Working with the Biblio Sample Database.- Appendix B CompareCursorLocation Chart.- Appendix C ADOc Dynamic Properties.