Practical Database Programming with Visual Basic.NET, 2nd Edition

The most up-to-date Visual Basic.NET programming textbook—covering both fundamentals and advanced-level programming techniques—complete with examples and solutions

Visual Basic.NET (VB.NET) is an object-oriented computer programming language that can be viewed as an evolution of the classic Visual Basic (VB), which is implemented on the .NET Framework. Microsoft currently supplies two major implementations of Visual Basic: Microsoft Visual Studio (which is commercial software) and Microsoft Visual Studio Express (which is free of charge).

Forgoing the large amounts of programming codes found in most database programming books, Practical Database Programming with Visual Basic.NET shows students and professionals both how to develop professional and practical database programs in a Visual Basic.NET environment by using Visual Studio.NET Data Tools and Wizards related to ADO.NET 4.0, and how to apply codes that are auto-generated by solely using Wizards. The fully updated Second Edition:

• Covers both fundamentals and advanced database programming techniques
• Introduces three popular database systems with practical examples including MS Access, SQL Server 2008, and Oracle
• Features more than fifty sample projects with detailed illustrations and explanations to help students understand key techniques and programming technologies
• Includes downloadable programming codes and exercise questions

This book provides undergraduate and graduate students as well as database programmers and software engineers with the necessary tools to handle the database programming issues in the Visual Studio.NET environment.

Table of Contents

Chapter 1 Introduction 1
Chapter 2 Introduction to Databases 10
Chapter 3 Introduction to ADO.NET 91
Chapter 4 Introduction to Language Integrated Query (LINQ) 149
Chapter 5 Data Selection Query with Visual Basic.NET 241
Part I Data Query with Visual Studio.NET Design Tools and Wizards 242
Part II Data Query with Runtime Objects 311
Chapter 6 Data Inserting with Visual Basic.NET 417
Part I Data Inserting with Visual Studio.NET Design Tools and Wizards 418
Part II Data Insertion with Runtime Objects 442
Chapter 7 Data Updating and Deleting with Visual Basic.NET 493
Part I Data Updating and Deleting with Visual Studio.NET Design Tools and Wizards 494
Part II Data Updating and Deleting with Runtime Objects 512
Chapter 8 Accessing Data in ASP.NET 559
Chapter 9 ASP.NET Web Services 657