Print this page Share

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

ISBN: 978-0-471-78513-2
585 pages
February 2006
Expert One-on-One Visual Basic® 2005 Database Programming (047178513X) 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 Downloads
Code downloads for this title are available here.
See More
Back to Top