Apress

Beginning VB 2008 Databases

From Novice to Professional

By Vidya Vrat Agarwal , James Huddleston

Beginning VB 2008 Databases Cover Image

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.

Full Description

  • ISBN13: 978-1-59059-947-1
  • 409 Pages
  • User Level: Beginner to Advanced
  • Publication Date: April 16, 2008
  • Available eBook Formats: PDF
  • Print Book Price: $44.99
  • eBook Price: $31.99
Buy eBook Buy Print Book Add to Wishlist

Related Titles

Full Description

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

What you’ll learn

  • How relational databases work and how to use them
  • How Visual Basic uses ADO.NET to access databases
  • How to write stored procedures in T-SQL and call them from Visual Basic programs
  • How to use XML in database applications
  • How to use LINQ to simplify VB database programming
  • How to install SQL Server 2005 Express and use it to teach yourself databases by doing databases

Who this book is for

Beginning VB 2008 Databases is for every VB programmer. Database programming requires relatively little knowledge of VB but a lot of knowledge about relational database concepts and the database language SQL. This book assumes no prior database experience and teaches you, always through hands-on examples, how to create and use relational databases with SQL and how to access them with VB. Almost every application needs to access a database, and this book teaches all the fundamentals you may ever need to develop professional database applications.

Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.

Errata

If you think that you've found an error in this book, please let us know about it. You will find any confirmed erratum below, so you can check if your concern has already been addressed.

* Required Fields

No errata are currently published