Print this page Share

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

ISBN: 978-0-7645-7678-2
624 pages
December 2005
Expert One-on-One Visual Basic® 2005 Database Programming (076457678X) cover image


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.

See More

Table of Contents



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.


See More

Author Information

Roger Jennings is the author of more than 20 books about Microsoft database platforms and Windows operating systems. He is also a principal of OakLeaf Systems, a columnist for Fawcette Technical Publications' online newsletters, and a contributing editor for Visual Studio Magazine. His U.S. Code of Federal Regulations Web services won the 2001 Microsoft .NET Best Award for horizontal solutions.
See More


Download TitleSizeDownload
Code Files - Part 1
To access the code, download both parts of the archive into the same directory, and run the installer (57678X_code.part1.exe).
9.00 MB Click to Download
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).
788.58 KB Click to Download
See More


Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.

ChapterPageDetailsDatePrint Run
Code Replacement / Errata Download
The code update for this title has been posted and may be accessed via:
8 Error in Text (Figure)
Figure 1-2, Top left block:

Text reads:

Should read:
9 Error 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
25 Error in Text (Figure)
Figure 1-5, Top left block:

Text reads:
"OLE CB Provider"

Should read:
"OLE DB Provider"
4 138 Typo
'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.
See More
Back to Top