Publisher's Synopsis
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. Carsten Thomsen is a Microsoft MVP, recognition he received in August 1999. He lives in his native Denmark and currently holds the MCSE and MCSD certifications. Carsten has been programming in Visual Basic for almost 10 years, with a specialization in data access. However, with the advent of Visual Studio .NET, he has concentrated on two programming languages, Visual Basic .NET and C#. Carsten is the author of the first edition of ¿Database Programming with Visual Basic .NET¿ and ¿Database Programming with C#¿, both from Apress.