Beginning Visual Basic .NET Databases

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

After working with Wrox Press on a number of projects since 1999, Matthew Reynolds is now an in-house author for Wrox Press writing about and working with virtually all aspects of Microsoft .NET. He's also a regular contributor to Wrox's ASPToday and C#Today, and Web Services Architect. He lives and works in North London and can be reached on matthewr@wrox.com.

Bill Forgey has several years of consulting experience in software design and development. He has created many applications using ASP, Delphi, Pascal, Visual C++, and Visual Basic and specialized in n-tier architecture using SQL, ADO, and COM development. Bill currently works as the Technical Lead at a large bank introducing project methodology, new technologies, and training to different development teams throughout the bank. Bill can be contacted via e-mail at bforgey@vbcentral.net.