Expert One-on-one Visual Basic 2005 Database Programming

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.

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.