Customer Reviews

ADO.NET and ADO Examples and Best Practices for VB Programmers (Second Edition)

5 star:		(7)
4 star:		(0)
3 star:		(3)
2 star:		(2)
1 star:		(0)

 

 

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.

As a purchaser of all of Bill Vaughn's Hitchhiker series books, this book was a bit of a disappointment. If you're looking for an ADO book, you can't go wrong. If you're looking for an ADO.Net book, keep looking. More than half the book covers ADO, which is surprising since the title leads with ADO.Net. I had purchased this book because previous BV books were extraordinarily helpful in learning database technologies, and I like his writing style and the callout tips. With ADO.Net, I was hoping for the detail found in previous books, and it's just not there (although I haven't finished the book yet).

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.

Given the "Best Practices" title, I assumed that this book was going to go into much more advanced lessons about real world problems and solutions for ADO.NET
Instead, I found a book filled with beginners guides to the database wizards included in Visual Studio.NET and "first you do this, then you do that" types of examples.

The author barely touches on designing N-tier architectures and instead spends most of the time comparing ADO.NET and ADO.

A decent book if you are experienced at ADO and are just now learning ADO.NET. Otherwise, stay away.

...When I have a question about data access this is the book I reach for. It has everything I need in an ADO reference. If you write both VB and VB.Net applications that use ADO or ADO.Net; you have to get this book. It covers how to use, and when to use each object in Classic ADO (the author refers to it as ADOc) and ADO.Net. It also covers how and when to use ADOc in the .Net Framework to accomplish things that were left out of ADO.Net. The author does a very good job in contrasting the DataSet with the DataReader and when you should use one over the other. This book is well written with just the right amount of humor, and covers data access in VB and VB.Net very well. If you are looking for the best ADO(.Net) reference and how to guide, you have found it.

tc

I have been reading Bill Vaughn's books since the first Hitchhikers book (and I still have them all!). I found this book to be excellent in content for ADO Classic. The references and examples were well structured and most of them worked! As always I enjoyed Bill's style and method of getting the correct detail to the reader. I won't judge the content on ADO.NET yet as it is still an emerging technology and I don't understand it fully but will be waiting for next release of Bill's book that covers ADO.NET specifically.

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.

The title indicates that the book will give you a practical view of the use of ADO.NET with examples. But two thirds of the book deals with ADOc. I needed practical information on how to use ADO.NET. This is not thruth on this book. If possible I would like to return it to the seller.

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!

This book has is full of great information on how to get the best database performance from your code. The chapter on the SHAPE command was especially helpful on how to speed up my code just by changing the syntax. This is a must-have book for anyone using ADO and ADO.NET.