Mastering Visual Basic.NET Database Programming

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