Beginning VB 2005 Databases: From Novice to Professional

Description

Beginning Visual Basic 2005 Databases teaches you everything you need to know about relational databases, SQL, and ADO.NET 2.0, giving you a sound start in developing console and Windows database applications. The book also includes chapters on the new SQL Server XML data type and the forthcoming LINQ enhancements to the next version of Visual Basic.

In addition to teaching you database basics like using SQL to communicate with databases, this book provides you with detailed, code-practical techniques to access data in VB 2005 across a range of coding situations. Code-heavy and full of practical detail, this book has been fully revised and upgraded for .NET 2.0 and offers you the best contemporary practice in this core programming area, so that youll find yourself using it in nearly all your .NET projects.

CONTENTS:

Chapter 1.Getting Our Tools

Chapter 2.Getting to Know Our Tools

Chapter 3.Introducing SQL

Chapter 4.Introducing ADO.NET

Chapter 5.Introducing Connections

Chapter 6.Introducing Commands

Chapter 7.Introducing Data Readers

Chapter 8.Introducing Datasets, and Data Adapters

Chapter 9.Introducing Data Binding

Chapter 10.Understanding Tables and Relationships

Chapter 11.Learning More about Queries

Chapter 12.Using Stored Procedures

Chapter 13.Handling Exceptions

Chapter 14.Using Transactions

Chapter 15.Working with ADO.NET Events

Chapter 16.Working with Text and Binary Data

Chapter 17.Using XML

Chapter 18.Introducing LINQ