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

Denise Gosnell, a Microsoft Certified Solution Developer, works for Microsoft as a consultant in the MCS National Retail Consulting Group. She received a Bachelor's degree in Computer Science - Business (summa cum laude) from Anderson University and a Doctor of Jurisprudence from Indiana University in Indianapolis. Denise is an attorney licensed to practice law in Indiana and is an active member of the Indiana and Indianapolis Bar Associations. She recently co-authored the MSDE Bible published by IDG Books in December 2000. Denise has worked in the computer industry for over 7 years. She hopes to find unique ways to utilize her diverse background in law and technology.

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.