Beginning Visual Basic 6 Database Programming

by John Connell

List Price:	~~$39.99~~
Average Rating:
Lowest New Price:	$5.03

Editorial Reviews
Product Description
Visual Basic 6 is the new release of the Microsoft's leading windows programming tool. There are over 3.2 million current users of Visual Basic in the world, ranging from novices to programming to experienced developers. Visual Basic 5 sold over 1m copies in 1997, an increase of over 40% over the previous year's sales. This is a large category that is on an exponential growth curve. Microsoft estimate that 70% of all development that is done with VB is database related. It's the leading tool for developing all database front ends, both to new applications, and to legacy systems. Beginning Visual Basic 6 Database Programming is out concurrently with the new release of VB6, it uses the same winning tutorial format as Beginning VB covering everything from database design, to SQL to client server all at a fast pace. There are practical hands on examples that are usable right from the book and it uses DAO to explain the basics of database programming in lucid tutorial format. Added to all this is the fact that it also covers new ADO technology in depth.

Amazon.com Review
This book covers all of the new and improved data-access features of Visual Basic 6 (VB6) and illustrates how to put the various components and techniques to work in real-world applications. The first chapter spells out the concepts of databases in general and then introduces the reader to the Data Control and the VB Data Form Wizard--a quick way to snap together a database interface. From there, author John Connell spends a few chapters illustrating how to code the data control and build a "bulletproof" user interface to your data.

After a discussion about planning your database structure, Connell steps you through the process of building a fully functional application that uses many important VB features. The chapters include screen shots, diagrams, and code snippets, with plenty of tips and step-by-step exercises. You can download the source code for the included examples from the publisher's Web site.

Once you have the preliminary education under your belt, the author presents Microsoft's Universal Data Access (UDA) architecture. He shows how to create your own data-bound ActiveX controls and use Active Server Pages (ASPs) to fetch and return database records via a Web browser. Connell finishes off this lengthy education with a brief foray into data mining and a discussion of how to export data to other applications. --Stephen Plain

Customers who bought this item also bought

All Customer Reviews
Average Customer Review: 4.5 out of 5 stars

2 of 2 people found the following review helpful:

5 out of 5 stars

I soon made $5,500.00 with this book, 2005-02-14
Prior to picking up John's book I had some familiarity with 'desktop' databases like Lotus Approach and MS Access, and had a beginner's understanding of the Basic Language, but felt to intimidated to actually code my own database from scratch in a major programming language.

After studying John's material and hand coding the examples (no copy and paste), I gained the confidence necessary to bid on a Database contract in the manufacturing sector. I won the contract. The database has been in production for over 4 years now.

The client recently asked me to upgrade it. This IS IMPORTANT, because John's emphasis on good database design, code optimization, and component reuse HELPED me to write code that I can easily return to and understand later when it's time for maintenance or upgrades.

And yes, there were two examples in his code that were broken, but they were minor mistakes and he teaches so well that I was able to fix it myself and make the examples work.

P.S. In the recommended titles below:
The first - is actually a great VB/MS HTML help reference.
The second - is by Dan Appleman. Dan's books are a MUST HAVE for serious VB developers.

Other Recommended Titles:
Microsoft Access 97 Developer's Handbook - MS Press
Developing COM/ActiveX Components with Visual Basic 6 - SAMS
Professional Active Server Pages 2.0 - Wrox
Java 2 Primer Plus - SAMS

2 of 2 people found the following review helpful:

5 out of 5 stars

Best of the Litter! VB and Database development with ADO, 2004-05-27
I strongly recommend purchasing a copy of Beginning VB6 Database.

WHY?
Top quality code that works!
Great working examples!
Gets you into the "preverbal" guts of VB Database programming.

Want to learn how ADO works? You will find in Johns book.

John's book has taken me well beyond the "basics" of VB database programming, with...

First rate screen shots of the applications development and the real world examples he presents as you move along from one chapter to the next.

And yes all with excellent easy to follow explanations and code.

Solid examples of good Class development. Well document/written/
Useful API code and more importantly it works!

And guess what John explains why!!!

I could go on and on, but I think you get the point.

Soooooooooo....
If you what get a grip on ADO, I can't think of a better place to start then with...
Beginning VB6 Database!!!

THANK YOU JOHN!!

1 of 1 people found the following review helpful:

5 out of 5 stars Good Starting Book For New Programmers, 2004-04-13
I purchased this book with the intention of getting a better idea of what I need to do to get a grasp on writing database driven applications.

This book is wonderful for those who have some VB experience and want to continue learning the more in-depth portions of Visual Basic.

I have also used this book in conjunction with my school as a reference guide for my database programming class.

0 of 11 people found the following review helpful:

2 out of 5 stars OK but not super perfect, 2003-03-20
Did not like the part that the book covers for the most part DATA controls for MS-Access programming. Not benefecial if your are gonna be using referencial code based coding reference source.

7 of 7 people found the following review helpful:

5 out of 5 stars Hurray for John Connell, 2003-02-27
Hurray for John Connell he speaks to us beginners on our level. It was also very encouraging when he mentioned that he did not get it the first time, he had a light bulb moment. I have never heard a guru admit that before they usually give the impression that it came very easy for them.

The exercises seemed to encompass a lot of VB functions, uses, and neat tricks. The explanations are complete, well thought out, and unambiguous. With little or no exposure to VB any programmer should be able to follow along.

My next goal is VB.Net I hope Mr. Connell will write/has written a book that addresses it. Wrox should adopt his style for all of their text books.

Price is accurate as of the date/time indicated. Prices and product availability are subject to change. Any price displayed on the Amazon website at the time of purchase will govern the sale of this product.