Beginning Visual Basic .Net Databases

Denise Gosnell, Matthew Reynolds, Bill Forgey9781861005557, 1861005555

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

---

Table of contents :
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