Beginning VB 2005 Databases: From Novice to Professional

✍ Scribed by James Huddleston, Ranga Raghuram, Syed Fahad Gilani, Jacob Hammer Pedersen, Jon Reid (auth.)

• Publisher: Apress
• Year: 2007
• Tongue: English
• Leaves: 503
• Edition: 1
• Category: Library

✦ Synopsis

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.

✦ Table of Contents

Front Matter....Pages i-xxvi
Getting Our Tools....Pages 1-15
Getting to Know Our Tools....Pages 17-43
Introducing SQL....Pages 45-66
Introducing ADO.NET....Pages 67-95
Introducing Connections....Pages 97-115
Introducing Commands....Pages 117-139
Introducing Data Readers....Pages 141-168
Introducing Datasets and Data Adapters....Pages 169-220
Introducing Data Binding....Pages 221-242
Understanding Tables and Relationships....Pages 243-265
Learning More About Queries....Pages 267-300
Using Stored Procedures....Pages 301-321
Handling Exceptions....Pages 323-343
Using Transactions....Pages 345-364
Working with ADO.NET Events....Pages 365-385
Working with Text and Binary Data....Pages 387-409
Using XML....Pages 411-436
Introducing LINQ....Pages 437-462
Back Matter....Pages 463-492

✦ Subjects

Programming Techniques