Mastering Visual Basic .NET Database Programming

Enter a New World of Database Programming

Visual Basic .NET and ADO.NET facilitate the development of a new generation of database applications, including disconnected applications that run on the Web. Mastering Visual Basic .NET Database Programming is the resource you need to thrive in this new world. Assuming no prior experience with database programming, this book teaches you every aspect of the craft, from GUI design to server development to middle-tier implementation. If you're familiar with earlier versions of ADO, you'll master the many new features of ADO.NET all the more quickly. You'll also learn the importance of XML within the new .NET paradigm. Coverage includes:

• Getting familiar with the ADO.NET object model
• Using the data access wizards
• Taking advantage of new SQL Server 2000 features
• Carrying out XSL Transformations and XPath queries
• Generating XML using the T-SQL FOR XML statement
• Binding controls to ADO.NET result sets
• Arriving at a sound database design
• Tuning your SQL Server 2000 database
• Using the XML Designer in Visual Studio .NET
• Leveraging the data access tools available in the Visual Studio .NET IDE
• Working with .NET data providers
• Choosing between streaming data and caching data
• Working with the Data Form Wizard in Visual Studio .NET
• Using advanced ADO.NET techniques
• Building a threaded application
• Using .NET's advanced exception handling capabilities
• Using the .NET Deployment Project Template

Contents

Introduction

Part 1 • Database Concepts
Chapter 1 • Database Access: Architectures and Technologies
Chapter 2 • Basic Concepts of Relational Databases
Chapter 3 • The Visual Database Tools
Chapter 4 • Structured Query Language

Part 2 • Database Programming
Chapter 5 • Transact-SQL
Chapter 6 • A First Look at ADO.NET
Chapter 7 • ADO.NET Programming
Chapter 8 • Data-Aware Controls
Chapter 9 • Working with DataSets
Chapter 10 • The Role of XML

Part 3 • Advanced Data Services
Chapter 11 • More ADO.NET Programming
Chapter 12 • Integration with XML
Chapter 13 • The Middle Tier
Chapter 14 • Advanced SQL Server 2000 Features

Part 4 • Data Access From the Web
Chapter 15 • Introducing ASP.NET
Chapter 16 • The Web Data Controls
Chapter 17 • Working with WebServices
Chapter 18 • VS .NET Deployment Considerations
Appendix A • Sample Projects
Index