Beginning Visual Basic .NET databases

This book has been fully tested on and is compliant with the official release of NET. Almost all applications have to deal with data access in some way or another. This book will teach you how to build Visual Basic .NET applications that make effective use of databases. Visual Basic .NET is the latest version of the most widely used programming language in the world, popular with professional developers and beginners alike. Starting with a guide to the basic principles of database design, we then examine how to query databases and how to access their data - both in Windows applications and remotely using the Internet and Web Services. Every new concept is explained thoroughly with Try It Out examples, plenty of code samples, and end-of-chapter questions to test you. This book covers: - The basic principles of relational database design - Microsoft SQL Server Desktop Engine - Querying the database with the T-SQL language - Visual Studio .NET and the Server Explorer - ADO.NET and the DataSet - Data binding, updating the database, and conflict resolution - XML's role in ADO.NET - Accessing data with ASP.NET and Web Services Title Page......Page 2 Introduction......Page 8 Chap 1 - Relational Database Design......Page 16 Chap 2 - Microsoft SQL Server 2000 Desktop Engine......Page 46 Chap 3 - Querying the Database......Page 84 Chap 4 - Exploring the Server Explorer......Page 112 Chap 5 - The User Interface for the Database......Page 136 Chap 6 - Data Access with ADO.NET......Page 182 Chap 7 - Reading Data into the DataSet......Page 246 Chap 8 - Data Binding......Page 302 Chap 9 - Updating the DataSet and Handling Errors......Page 350 Chap 10 - Conflict Resolution......Page 390 Chap 11 - ASP.NET......Page 416 Chap 12 - ADO.NET and XML......Page 460 Chap 13 - Web Ser vices......Page 512 Chap 14 - Disconnected Data......Page 568 Case Study – B2B Application Integration using XML......Page 632