Expert One-on-One Visual Basic 2005 Database Programming (Paperback)

~ (Author)

Editorial Reviews

Product Description

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.

From the Back Cover

Are you hesitant to migrate to Visual Studio® 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® 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 all Editorial Reviews

Product Details

• Paperback: 624 pages
• Publisher: Wrox (December 19, 2005)
• Language: English
• ISBN-10: 076457678X
• ISBN-13: 978-0764576782
• Product Dimensions: 9.2 x 7.4 x 1.5 inches
• Shipping Weight: 2 pounds (View shipping rates and policies)
• Average Customer Review: 4.5 out of 5 stars  See all reviews (11 customer reviews)
• Amazon.com Sales Rank: #348,167 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

13 of 13 people found the following review helpful:

5.0 out of 5 stars An outstanding book about database Programming with Visual Basic 2005, February 7, 2006

By	Dominik Galli (Switzerland) - See all my reviews (REAL NAME)

There are books that show you the new features of database programming with Visual Basic 2005, but it's up to you (your experience or imagination) how to use them in your projects. This book shows you in a great way how to implement the new features in non trivial Windows Forms and ASP.NET 2 projects! It's not a book that you read in just a week; you should really take you time and study it (and also the source code which the author has updated to the final release of VS 2005). Ok. some readers will say that some of the code could be placed in a separate class/tier, but in my eyes that don't affect the learning effect.
At the moment this book is my absolute favourite about database programming with visual basic 2005. If you are also interested in this topic, I can only recommend this book.

7 of 7 people found the following review helpful:

5.0 out of 5 stars Great Practical information - unbelievably good, July 12, 2006

By	William Smith "Amazon Fan" (Hsv Al) - See all my reviews (REAL NAME)

I bought this book even though I am a C# coder. Roger has such great concepts on how to do design and coding that I almost shouted for joy after searching and reading other books (e.g S. Malik which is of little or no value). This book goes beyond my production code needs and is invaluable in doing it right the first time. Thanks Roger for the section on concurrency exceptions which we all have in the real world. Most folks sweep this under the rug because it takes a real pro to fully and accurately address it.

15 of 18 people found the following review helpful:

3.0 out of 5 stars Not sufficiently comprehensive, April 17, 2006

By	Israel Ramirez (Springfield, PA) - See all my reviews (REAL NAME)

I was looking for something that would show me how to do the things I routinely do in Access and VB6. This book is a bit of hit and miss on that score. It has a good discussion of how to avoid concurrency problems, how to setup a Master Details form, and new festures of SQL Server 2005. But a lot of basic topics are missing. For example, what is the best way to update data in an existing row in a table? The lengthy walkthroughs are very detailed but going through them takes a long time and may not provide an answer for the problem the reader is trying to solve. This book only answered half of the problems I asked of it.