Skip to main content

Expert One-on-OneTM Visual Basic® 2005 Database Programming

Expert One-on-OneTM Visual Basic® 2005 Database Programming

Roger Jennings

ISBN: 978-0-471-78513-2

Feb 2006

585 pages

Select type: E-Book

Product not available for purchase


Are you hesitant to migrate to Visual Studio(r) 2005? Maybe you're ready to upgrade to Visual Basic 2005 but feel a bit overwhelmed by ADO.NET 2.0 and the Visual Data Tools of this new release. In this hands-on guide, I'll share with you the best practices, the latest features, and advanced data management techniques with Visual Basic 2005 and SQL Server or SQL Server Express 2005. Plus, I'll incorporate simple to moderately complex project examples that feature real-world, database front-end applications with Windows and Web forms.

First, I'll begin with ADO.NET 2.0 basics, then I'll move on to designing and programming smart clients with typed DataSets as their data sources. Gradually, I'll walk you through using DataSource, GridView, and DetailsView Web controls. Finally, I'll demonstrate how to take advantage of the new T-SQL extensions, in-process Web services, and notifications.

What you will learn from this book

  • How to build usable Windows(r) and Web forms from a sample database in less than five minutes-without writing a line of code
  • Effective writing of data validation code for bound text boxes and DataGridViews
  • Ways to apply advanced ASP.NET 2.0 data techniques
  • The process of creating and deploying VB 2005 SQL CLR projects

Who this book is for

This book is for experienced VB programmers who are upgrading from VB6 or VS 2002/2003 to VB 2005. Basic familiarity with the VS 2005 or VB Express 2005 environment is helpful but not assumed. No prior VB6, VBA, or VBScript experience is necessary.

Wrox Expert One-On-One books present the wisdom accumulated by an experienced author who is recognized as an expert by the programming community. These experts challenge professional developers to examine their current practices in pursuit of better results.



Part I: ADO.NET 2.0 Basics.

Chapter 1: Migrating from ADO to ADO.NET.

Chapter 2: Introducing New ADO.NET 2.0 Features.

Chapter 3: Adopting Best Practices for Data-Centric Projects.

Part II: Data Binding in Windows Forms and Controls.

Chapter 4: Programming TableAdapters, BindingSources, and DataGridViews.

Chapter 5: Adding Data Validation and Concurrency Management.

Chapter 6: Applying Advanced DataSet Techniques.

Part III: Data Binding in ASP.NET 2.0.

Chapter 7: Working with ASP.NET 2.0 DataSources and Bound Controls.

Chapter 8: Applying Advanced ASP.NET 2.0 Data Techniques.

Chapter 9: Publishing Data-Driven Web Services.

Part IV: SQL Server 2005 and ADO.NET 2.0.

Chapter 10: Upgrading from SQL Server 2000 to 2005.

Chapter 11: Creating SQL Server Projects.

Chapter 12: Exploring the XML Data Type.


Code Files - Part 1
Code downloads for this title are available here.
Code Downloads
Code downloads for this title are available here.
Code Files - Part 1
Code downloads for this title are available here.
Code Downloads
Code downloads for this title are available here.
Code Files - Part 2
To access the code, download both parts of the archive into the same directory, and run the installer (57678X_code.part1.exe).
ChapterPageDetailsDatePrint Run
Code Replacement / Errata Download
The code update for this title has been posted and may be accessed via:,descCd-download_code.html

8Error in Text (Figure)
Figure 1-2, Top left block:

Text reads:

Should read:

9Error in code
running code returns error message:
There is already an open datareader associated with this command which must be closed first.

to fix:
remove the code line that reads:
sdrReader = cmdReader.ExecuteReader

25Error in Text (Figure)
Figure 1-5, Top left block:

Text reads:
OLE CB Provider

Should read:
OLE DB Provider

'Clean Up the UI and Code':
Bullet point 2 should read:

. . . delete the FillByCustomerIDToolStripButton_Click and FillByCustomerIDToolStripButton1_Click

Note the removal of the number '1' in the earlier click event.