|
ADO.NET and ADO Examples and Best Practices for VB Programmers (Second Edition)
 |
Author: William R. Vaughn, Bill Vaughn
List Price: $54.95
Our Price: Click to see the latest and low price
ISBN: 1893115682
Publisher: APress (01 January, 1970)
Edition: Paperback
Sales Rank: 109,642
Average Customer Rating: 4.1 out of 5
|
Customer ReviewsRating: 5 out of 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
Rating: 3 out of 5
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.
Rating: 3 out of 5
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.
Similar Products
· Programming Microsoft Visual Basic .NET (Core Reference)
· Murach's VB.NET Database Programming with ADO.NET
· Programming VB .NET: A Guide for Experienced Programmers
· Expert One-on-One Visual Basic .NET Business Objects
· Moving to VB .NET: Strategies, Concepts, and Code, Second Edition
|
