Beginning VB 2008 Databases: From Novice to Professional

✍ Scribed by Vidya Vrat Agarwal, James Huddleston (auth.)

• Publisher: Apress
• Year: 2008
• Tongue: English
• Leaves: 409
• Edition: 1
• Category: Library

✦ Synopsis

Beginning VB 2008 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 SQL Server XML data type and the 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 Visual Basic 2008 across a range of coding situations. Code-heavy and full of practical detail, this book has been fully revised and upgraded for .NET 3.5 and offers you the best contemporary practice in this core programming area, so that you'll find yourself using it in nearly all your .NET projects.

• Provides step-by-step instructions on how to install and configure necessary tools
• Presents all essential SQL query and update concepts and syntax, so you don't need prior familiarity with relational databases or SQL
• Describes how to use ADO.NET transactions, exceptions, and events
• Covers ADO.NET features for handling XML, text, and binary data within a Visual Basic 2008 context
• Explains all concepts through straightforward code examples

✦ Table of Contents

Front Matter....Pages i-xxviii
Getting Your Tools....Pages 1-13
Getting to Know Your Tools....Pages 15-24
Getting to Know Relational Databases....Pages 25-34
Writing Database Queries....Pages 35-65
Manipulating Database Data....Pages 67-87
Using Stored Procedures....Pages 89-107
Using XML....Pages 109-121
Understanding Transactions....Pages 123-141
Getting to Know ADO.NET....Pages 143-168
Making Connections....Pages 169-184
Executing Commands....Pages 185-202
Using Data Readers....Pages 203-224
Using Datasets and Data Adapters....Pages 225-266
Building Windows Forms Applications....Pages 267-292
Building ASP.NET Applications....Pages 293-311
Handling Exceptions....Pages 313-330
Working with Events....Pages 331-341
Working with Text and Binary Data....Pages 343-364
Using LINQ....Pages 365-378
Using ADO.NET 3.5....Pages 379-394
Back Matter....Pages 395-409

✦ Subjects

Programming Languages, Compilers, Interpreters