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.
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 |
