Beginning Visual Basic 6 Database Programming

by John Connell and John Connell

Book Overview

This book introduces you to databases and takes you all the way through to the latest ADO technologies in Visual Basic 6. Step by step, this book will help you to build working database components and applications in Visual Basic. Whether you want to work with databases on your desktop, get access to legacy data, or program database access across the Internet, this is the book that will get you started.

• Format: Paperback
• Language: English
• ISBN: 1590592514
• ISBN13: 9781590592519
• Release Date: September 2003
• Publisher: Apress
• Length: 880 Pages
• Weight: 3.26 lbs.
• Dimensions: 1.8" x 7.3" x 9.4"

Customer Reviews

Good Solid VB Programming - Not Just Database

John Connell should have been a teacher. I have about 1 dozen VB books, and this is in the top two of my favorites and probably always will be. If you understand basic (sorry, no pun)VB and want a good intro to database connectivity(DAO, ADO, ASP, SQL)stuff then definitely buy this book. There are also great sections on object-oriented programming like creating data handling classes and Active X controls for code reuseability. I found the midsection discussion on relational database design (normal form design, key constructs, SQL queries, etc.) an excellent refresher. The ending section and example on Data Mining was just too cool and really showed me how database programming could be much more than simply keeping track of who has what zip code.If I had one suggestion for improvement it would be to look at connectivity issues with databases other than Access. Connecting to legacy systems like Dbase, or more esoteric ones like Filemaker are currently "try and see" experiments for me. I sure wish John would hold my hand there too!

Just what the Doctor ordered

I was recently assigned a task to write a db app for our department using VB 6.0. There are quite a few book selections to choose from - and a lot of noise on the book shelves (real and virtual). After researching a few, I picked up Connell's book. Not only did it get me going - it provided me with ideas that I NEVER would have thought of. The state machine and bullet proof interface techniques are ingenious. With this single book, I am well on my way to having the high visibility project done ahead of schedule. Ive never done things like write to the editor, etc. But in this unique case felt I had to let everyone know what an exceptional book this is. Real world, excellent examples, and a display of knowledge that is obvious came from walking the technical walk

A brilliant book!

As an introduction to Visual Basic, or as an introduction to Relational Databases, but especially as an introduction to how the two work together, this book is superb! Serves as a better intro to VB6 than most introductory books on the market, while at the same time tackling an essential subject thoroughly and clearly. I would strongly recommend this book to anyone wishing to learn more about this subject, or to anyone simply wanting to learn Visual Basic. A great buy!

Absolute Must for VB6 Database Programmers

I would like to congratulate you for producing Beginning VB6 Database Programming by John Connell. The book is well structured, the chapters can be studied independently. The explanations are very thorough, and clear, the style gave me complete confidence in the author and the feeling that no stones were left unturned. This opinion is evidenced by the Bullet Proof User Interface which is built, incrementally over chapters 4 -7, leading to an excellent Data Control Class Module and Form Templates which have been designed for code reusability. Chapter 10 provides an excellent Address book application using many features of VB for the design and implementation of the foundations of a professional contact management system. The background and history of ADO is clearly and thoroughly documented to provide a solid understanding of the many technologies involved in Database access and how ADO simplifies data access using Universal Data Access for both relational and non relational data sources. Chapter 12 provides an excellent ADO Data Bound ActiveX Control which enables code re-use in a multitude of applications. Chapter 13 is an excellent introduction to Acitve Server Pages and ADO with a really useful Cookie application which incorporates many of the features of using Active Server Pages, using HTML, Server Side Scripting using Visual Basic, ADO for database connectivity and an Active X Dynamic Link Library to exploit the power of VB6 and keeping the Data Centric code close to the database, separate from the User Interface, and again, designed for re-usability in other applications. Chapter 14, Advanced ADO Programming - Data Mining. This is a suberp application which has huge potential in many organisations with corporate data. The data mining technique is employed in a professional front end, user interface, which can easily be tailored to many business specific scenarios which require Business Intelligence uncovering hidden trends in their corporate databases. Finally, Chapter 15, really tops it off, with the capability to provide data exporting features for all database applications. The ability to export data from a database in a variety of formats, including Excel, HTML and CSV is invaluable to every application developer. The ability to disconnect a Recordset and make it persistent has huge potential in Internet applications. The book has, throughout, many useful coding tips to improve the speed of display of Forms, using Events, and writing fast code using the With Statement and storing of static values as variables for fast code execution. Very Professional. I started the book in the Cookie Chapter 13, then 14 then 15. I then worked my way back to Chapter 8. Then I worked forward, to finish with Chapter 7. Thank you, I've learned heaps from the book. Big respect to John Connell, he is the man.

Excellent starting point to learn practical VB skills

I strongly recommend purchasing a copy of Beginning VB6 Database, John Connell, Wrox, ISBN 1-861001-06-1. This book is superb. It's well written, easy to follow, and uses practical real-world-example-type labs to get you quickly up to speed on DB access and writing GOOD user interfaces. It also shows how to write re-usable code for those interfaces. If you don't feel like coding the examples they can be downloaded from the Wrox web site. I've learned a bunch of simple little things to improve my VB skills in the first 200 pages. This is essential reading if you want to learn VB skills that you can apply to business solutions, and it doesn't take a lot of time to get through the chapters. I can't say enough good things about this book. Probably the best "how to" computer book I've ever read. It also covers ADO 2.0. I checked it out from the library and was so impressed I purchased my own copy.