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. 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