Database Programming with Visual Basic .NET, 2/e

You can read Database Programming with Visual Basic .NET, Second Edition cover-to-cover, or use it as a reference book for its many listings with ready-made solutions of "drop-in" code. This book will teach you the concepts of disconnected data access with ADO.NET; how to create various database details, such as tables, constraints, projects, stored procedures, views, and triggers; how to use SQLXML 3.0 with SQL Server 2000; how to incorporate message queuing into applications using MSMQ 3.0; and more. You'll learn how to master ADO.NET both from within the VS. NET IDE and programmatically.

One of the most popular features carried over from the first edition is the real-world sample application that Carsten builds throughout this book. It's a user management system that's based on SQL Server, Active Directory, and Message Queuing. With this example code, you can connect to SQL Server using any of the three .NET Data Providers: SQL Server .NET Data Provider, OLE DB .NET Data Provider, or ODBC .NET Data Provider. The example code also includes how to connect to and manipulate data in MySQL 3.23.51 or later, Oracle 9i or later, Microsoft Access 2000 or later, and, of course, SQL Server. You will also find guidance on connecting to SQL Server 2000 using the SQLXML 3.0 plug-in to transfer data using XML from managed code or HTTP. Exchange Server 2000 data manipulation is also covered, with original working code.

Database Programming with Visual Basic .NET, Second Edition is the ultimate resource for developers needing to master database programming, written by a recognized Microsoft MVP.

Contents

Part One Getting Started with .NET and Databases
Chapter 1: A Lightning-Quick Introduction to Visual Basic .NET
Chapter 2: Using Databases

Part Two ADO.NET Connected Layer Reference
Chapter 3: Understanding ADO.NET
Chapter 4: Looking at Data Providers
Chapter 5: Connections and Transactions
Chapter 6: The Command and Parameter Classes
Chapter 7: DataReaders
Chapter 8: The DataAdapter and CommandBuilder Classes

Part Three ADO.NET Disconnected Layer Reference
Chapter 9: The DataSet Class
Chapter 10: The DataTable and DataView Classes
Chapter 11: The DataRow and DataColumn Classes
Chapter 12: Data Relations

Part Four Working with Databases in the VS .NET IDE
Chapter 13: Presenting the IDE from a Database Viewpoint

Part Five Exception Handling and Debugging
Chapter 14: Exception Handling
Chapter 15: Using the Debug and Trace Classes

Part Six Server-Side Processing
Chapter 16: Using Stored Procedures
Chapter 17: Using Views
Chapter 18: Using Triggers

Part Seven Hierarchical Databases
Chapter 19: Hierarchical Databases
Chapter 20: Exchange Server

Part Eight Message Queuing
Chapter 21: Message Queues

Part Nine XML and SQL Server 2000
Chapter 22: Using XML with SQL Server 2000

Part Ten Data Wrappers
Chapter 23: Data Wrappers

Part Eleven Data-Bound Controls
Chapter 24: Windows Data-Bound Controls
Chapter 25: Web Data-Bound Controls

Part Twelve Example Application
Chapter 26: UserMan

Appendixes
Appendix A Cursors and Locking
Appendix B Using Classic ADO and COM Interop
Appendix C Connected Layer Properties, Methods, and Events
Appendix D Disconnected Layer Properties, Methods, and Events