ADO.NET and ADO Examples and Best Practices for VB Programmers (Second Edition) (ISBN 1893115682) Book Reviews 1-7 Sorted By Most Recent, at VeryWellSaid.com

Great book!

THANK YOU for a great book! I purchased it and have not stopped reading.

While this time around I am reading only, next time I will
get the code going too. I will recommend this to everyone!

(Review Data Last Updated: 2008-11-18 10:07:45 EST)

09-01-03

2\5

Buy It

Like all of Bill's work, this book kicks butt. If you do anything more than lightweigth ADO.NET programming, make sure you add this to your library

(Review Data Last Updated: 2008-11-04 07:17:27 EST)

07-31-03

13\15

Good, but lacking important info

First off, the first half of this book talks about working with ADO in VB6, scared me at first but the second half talks about ADO for VB .NET. So, right off the bat 1/2 of this book is most likely useless to you depending on what you use or want. Goes into great detail about gotcha's, speed, interesting methods like using stored procedures and how the dataset is handled and what to watch out for. My problems, he does not mention how to bind a control through code. For example, have a form that has a grid/listbox and when the user clicks on an element have it display more detailed info about that record in labels & textboxes which are bound to the record... won't find it here and that's like basic 101 stuff. Maybe you want a parent child record, with the parent in text boxes and labels, and the child to be a grid (sort of like the tutorial but a little more advanced since it too does not show textboxes/labels). No help here. Also, all his examples appear to be just single-form based. I wanted to know more about how to program connecting to a database across multiple forms. Why, I even wanted to create a single connection object and use it across multiple forms... or have a database application on multiple forms... another basic database example. No help found in the book, after 18 hours I finally crawled my way and found how to do it myself and how darn simple! But, if you don't know where to begin (this book was no help) it's difficult and tedious. Now that I know I'm kicking myself.

In the end this book fulfilled me half way. I wanted to know how to program an application across multiple forms that connect to a database, how best to use the same connection object across those forms, and how to bind textboxes/labels through code and how to update, delete, and insert records that way. This book has left me in near utter darkness on how to do that. I wanted to know about parent/child relations and this book had very little to offer as far as I'm concerned in respect to examples (there's one). However I have a complete understanding of how to connect to a datasource, access columns, set up parameters, access stored procedures, and some knowledge of parent/child relations, some gotcha's of using the fill method, how to set filters, and sorts on the returned recordsets, and a good understanding of updating/deleting/inserting and how to intervene with those operations... also foreign constraints so that's why I give it an average rating.

(Review Data Last Updated: 2008-02-13 05:59:12 EST)

07-30-03

7\10

Pretty good, missing a very important feature IMHO

The first half of the book is old technology (VB6), I was nervous when I ripped it open and began reading the first couple chapters... then I saw the second half is about ADO .NET or database programming for VB .NET (phew!). So, depending on what you're using 1/2 of the book will be useless for you. I happen to be going from VB6 to VB .NET. He explains through great detail and with surgical precision what things are, how to connect to stored procedures, all sorts but it's all based on datasets. For example, like most people my program has multiple forms. This book was useless on helping me re-use a connection. I began programming each form needing to open a connection when necessary each and every time. I figured out myself (after about 18 hours) how to use a connection from another form and had to scoff at how easy... but it's one of those things that takes forever until you get it. Another is binding controls in VB .NET. If in code I create the connections and dataset and I want a textbox to display the customer name, you won't find the answer in this book and I think that's basic stuff. The thought of having an example where you select a customer from a grid and display the info of that customer on labels or textboxes bound to the record is no where to be found in this book. I'd like to know how to update/delete them as well from those textboxes but as said previously the only control used in the entire VB .NET section is a datagrid, you'll know more about datagrids than you'll know what to do with and I think he should've branched it a little to other controls. Now, I'm searching on my own again on how to bind a dataset to a textbox.

(Review Data Last Updated: 2008-02-13 05:59:12 EST)

04-16-03

2\5

A practical and useful guide to ADO .net

Bill's work on data access is well known and has been for some time. But this work really shines - it's useful, practical, even enjoyable reading! Most importantly, it speaks to developers like me with an understanding of what we need to get things done.

This is hands down the best of a considerable number of books on ADO .net.

(Review Data Last Updated: 2008-02-13 05:59:12 EST)

12-25-02

6\7

Excellent for VB progammers moving to .NET

I did not read the first half of the book, which covers ADO, but the second half, on ADO.NET is great! The style is easy to follow, the examples make sense and there are almost zero proofreading errors (which makes the book a standout among programming books by itself). The code examples in the text, are minimal, but the CD has the complete code and more. The examples on the CD work (another standout feature). This book is not for a beginning programmer, but it very good for an experienced progammer trying to make the move to ADO>NET, it was the 6th book that I read on the subject and after reading it, I was able to go back to my other books and understand things that had not made sense the first time I read them.

(Review Data Last Updated: 2008-02-13 05:59:12 EST)

07-09-02

1\2

Excellent performance tuning examples