Visual Basic.NET Database Programming [Paperback]

Rod Stephens (Author)

Book Description

Publication Date: April 21, 2002 | ISBN-10: 0789726815 | ISBN-13: 978-0789726810 | Edition: 1

Visual Basic.NET Database Programming walks the readers step-by-step through the topics they need to know to use databases effectively. This book teaches with real-world scenarios how to load, display, manipulate, modify and save data in databases. It shows the reader how to build multi-tier applications that implement enterprise-wide business solutions, build Web Servers, manage large amounts of data, find specific records, sort data, perform complex queries, and use XML--an integral part of data handling in Visual Basic.NET.

Editorial Reviews

From the Back Cover

Visual Basic.NET Database Programming walks the readers stepbystep through the topics they need to know to use databases effectively. This book teaches with realworld scenarios how to load, display, manipulate, modify and save data in databases. It shows the reader how to build multitier applications that implement enterprisewide business solutions, build Web Servers, manage large amounts of data, find specific records, sort data, perform complex queries, and use XMLan integral part of data handling in Visual Basic.NET.

About the Author

Rod Stephens began life as a mathematician but, in the 1980s at MIT, discovered the joys of computer algorithms and has been programming professionally ever since. During his tenure at GTE Laboratories, he used relational databases to build several large award-winning applications that are still in use today. More recently he has worked on projects ranging from tax software for the state of Minnesota to a training system for professional football teams.

Rod has written 12 programming books that have been translated into several languages, and more than 150 magazine articles covering Visual Basic, Visual Basic for Applications, Delphi, and Java. His popular VB Helper Web site (www.vb-helper.com) receives more than a million hits per month. VB Helper includes information on RodÕs books, essays, tutorials, and more than a thousand example programs for Visual Basic programmers.

Product Details

• Paperback: 416 pages
• Publisher: Que; 1 edition (April 21, 2002)
• Language: English
• ISBN-10: 0789726815
• ISBN-13: 978-0789726810
• Product Dimensions: 9.1 x 7.4 x 0.9 inches
• Shipping Weight: 1 pounds (View shipping rates and policies)
• Average Customer Review: 3.8 out of 5 stars  See all reviews (4 customer reviews)
• Amazon Best Sellers Rank: #1,606,288 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

11 of 11 people found the following review helpful:

5.0 out of 5 stars If you are ready for it, December 26, 2002

By 

Bob Hoffman (New Jersey) - See all my reviews

This review is from: Visual Basic.NET Database Programming (Paperback)

This is a great book for breaking into ADO.net, if:

(1) You are familiar with VB.NET and RDBMS concepts and have programmed production database applications with VB6 or other older technologies.

(2) You are not familiar with ADO.net or at least not enough to put an actual application together.

This book will provide a quick, yet thorough, path to fluency using WINFORMs with SQL Server using ADO.net. You have to read the necessary text and code samples thoroughly, and probably repeatedly.

ADO.net is the most powerful and elegant database technology from Microsoft so far. It is very productive if you understand and apply it fully.

The entire book is useful and well written, but the following chapters, in my opinion, are the salient ones for an experienced programmer trying to understand ADO.net:

Chapter 5 - Datasets. ADO.net represents an application's view of RDBMS data as an "in memory database" called a Dataset, complete with various mechanisms for tracking all aspects of transaction processing. Understand this new model completely.

Chapter 6 - Database Connections. The DataAdapter is the new class used for carrying out the actual transactions. Understand it and its associated classes thoroughly. Each DataAdapter contains and carries out commands for Retrieving (Filling), Inserting, Updating, and Deleting sets of rows for a specific DataTable of a Dataset. These commands are most conveniently built by the CommandBuilder. Once you understand this last sentence, you are in good shape.

Chapter 8 - Bound Controls are largely the same as old ADO, but be aware of how a Datagrid bound to a Datatable, when used properly, automates implementation of line items such as order lines.

Chapter 10 is the first chapter that pulls it all together into an operating Windows Form application. Once you understand how the Dataset and DataAdapter families of classes are used here, you are well on your way. You might even start with this chapter for HOW it works and then refer back to the earlier chapters for WHY it works.

Chapters 11 and 12 expand to a robust application of production quality, introducing the necessary multiuser hooks and better UI for queries.

6 of 6 people found the following review helpful:

4.0 out of 5 stars very good, but not for everyone, July 12, 2003

By 

"mgunnie" (LOKEREN, OVL Belgium) - See all my reviews

This review is from: Visual Basic.NET Database Programming (Paperback)

Let's start with the (little) negative part, and that's the way this book is organized. In my opinion the first 4 chapters and the appendix A/B should be presented in a different way. I'll see many people starting with chapter 5, or even with the appendix if you need to refresh your knowledge about SQL.
During the past years, i have been working on database apps. with VB6 and SQL Server, and since a while, i had been experimenting a little with data in the .NET environment. In my case, this was the book I needed, because the author does not waste too much time on explaining how to create your first stored proc or how VB works.
Also, he doesn't compare the old ADO with the new ADO .NET which you will see in many other books. No, in chapter 5 you'll get everything to know what you need about the Dataset, maybe some stuff you knew before, but with the details you need, and things start to become more interesting in chapter 8 until the end of the book.
If you are looking for a way to create a quick, nice user interface
by using a datagrid for example this is not the book for you, because these are hardly mentioned.
Instead of this, you'll get to know how to work with xml data, master/detail rel., data binding, images, multi user, query by example,etc. in other words, the data itself.
Excellent book, in case you know the basics about VB .NET and if you've been playing a little bit with ADO .NET, and need to go a step further. However, have a look at the content before you buy.

Gunther

7 of 8 people found the following review helpful:

4.0 out of 5 stars Good coverage of WinForms & Data Binding, July 24, 2002

By 

G. Knox (Richmond, CA United States) - See all my reviews
(REAL NAME)   

This review is from: Visual Basic.NET Database Programming (Paperback)

For an experienced programmer. This book provided what I needed to understand using databases in a WinForms environment (I had used ADO.NET for ASP.NET applications). The first 7 chapters cover database basics and an overview of the data bound controls (moderately valuable for an experienced programmer). I found the real substance (in my case) in Chapters 8, 10, and 11.

Chapter 8 covers a data entry form, how to bind data, navigate, and save changes. The first example is covered in detail the form is then enhanced with record selection options (a listbox, a treeview, and a filtered list box) only key items are discussed in the text (you need to review the downloadable code to fully understand, I like that the little things are not repeated).

Chapter 10 works with an order entry form with multiple DB data tables being maintained and navigating through the twists. Again, several approaches are presented so that you can choose the one with the look & feel you like. Chapter 11 discusses the mult-user situation.

I feel that these examples and clear writing allowed me to make the leap into data bound forms (I came from mostly Access programming where that is well handled). 4 stars because I would like to have seen some discussion/examples of an application with multiple screens and suggestions on how to address a slightly bigger application, but the book delivers on its stated goals.