Mastering Database Programming with Visual Basic 6 [Paperback]

Book Description

ISBN-10: 0782125980 | ISBN-13: 978-0782125986 | Publication Date: January 18, 2000

Meet the Challenge of Any Database Project with Visual Basic and ADOMastering Database Programming with Visual Basic 6 offers highly focused coverage of the techniques that make Visual Basic the ideal tool for database development. Assuming no prior experience with database programming, this book teaches you every aspect of the craft, from GUI design to server-side development to middle-tier implementation. Rather than waste your time with outmoded data access technologies, it takes you straight to the leading edge--ADO 2.5--helping you build database applications that will meet your organization's needs now and into the future. Coverage includes:
* Understanding data access architectures and technologies
* Understanding relational database concepts
* Getting acquainted with SQL, including the most important features of SQL Server 7 for the VB programmer
* Understanding ADO and what it offers your database application
* Using the visual database tools
* Using ADO 2.5 to access databases from within your VB applications
* Getting the most from SQL Server using T-SQL and stored procedures
* Simplifying client application coding with stored procedures
* Constructing data-aware classes
* Implementing middle-tier components and data-bound ActiveX controls
* Supporting remote data access
* Encapsulating database operations with ActiveX controls
* Accessing a database from within Web applications using Active Server Pages
* Building applications that work with Internet Information Server and Microsoft Transaction Server
* Mapping data structures to hierarchical Recordsets and making the most of disconnected Recordsets

Editorial Reviews

From the Back Cover

Meet the Challenge of Any Database Project with Visual Basic and ADOMasteringDatabase Programming with Visual Basic 6 offers highly focused coverage of thetechniques that make Visual Basic the ideal tool for database development.Assuming no prior experience with database programming, this book teaches youevery aspect of the craft, from GUI design to server-side development tomiddle-tier implementation. Rather than waste your time with outmoded dataaccess technologies, it takes you straight to the leading edge--ADO 2.5--helpingyou build database applications that will meet your organization's needs now andinto the future. Coverage includes:

• Understanding data accessarchitectures and technologies
• Understanding relational databaseconcepts
• Getting acquainted with SQL, including the most important featuresof SQL Server 7 for the VB programmer
• Understanding ADO and what it offersyour database application
• Using the visual database tools
• Using ADO 2.5to access databases from within your VB applications
• Getting the most fromSQL Server using T-SQL and stored procedures
• Simplifying client applicationcoding with stored procedures
• Constructing data-awareclasses
• Implementing middle-tier components and data-bound ActiveXcontrols
• Supporting remote data access
• Encapsulating database operationswith ActiveX controls
• Accessing a database from within Web applications usingActive Server Pages
• Building applications that work with Internet InformationServer and Microsoft Transaction Server
• Mapping data structures to hierarchical Recordsets and making the most of disconnected Recordsets

About the Author

Evangelos Petroutsos is a computer engineer who gained much of his experience at the California Institute of Technology and MCI. Currently, he writes computer books and works as a computer communications consultant. He has authored and co-authored dozens of programming titles, including the best-selling Mastering Visual Basic 6, and Visual Basic 6 Developer's Handbook. He also has published numerous articles and teaches networking and programming courses.

Product Details

• Paperback: 896 pages
• Publisher: Sybex (January 18, 2000)
• Language: English
• ISBN-10: 0782125980
• ISBN-13: 978-0782125986
• Product Dimensions: 9 x 7.6 x 2.3 inches
• Shipping Weight: 3.4 pounds
• Average Customer Review: 2.5 out of 5 stars  See all reviews (11 customer reviews)
• Amazon Best Sellers Rank: #1,010,466 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

17 of 18 people found the following review helpful:

3.0 out of 5 stars The book that covers little of everything, March 24, 2000

By 

B. Patel (Canada) - See all my reviews
(REAL NAME)   

This review is from: Mastering Database Programming with Visual Basic 6 (Paperback)

This book starts with visual tools of VB 6, teaches SQL, somewhat ADO, T-SQL, ASP, and introduction of the wizards supplied by VB. In short it is not a book to master database programming with VB but if you want an overview of how VB 6, SQL Server 7 and ASP are used togther to develop an online database application this book might help. It also provides few complete examples that covers all of this topics.

7 of 7 people found the following review helpful:

3.0 out of 5 stars Mixed emotions, October 19, 2001

By 

Robert L. Grant "rgrgrg" (San Jose, CA United States) - See all my reviews
(REAL NAME)   

This review is from: Mastering Database Programming with Visual Basic 6 (Paperback)

I am using this book as the selected text for a second course in Visual Basic. I am about half way through the text. The main objections I have to the book are that the author jumps around between SQL server and Access, often without telling you which one ( or even which of several example databases) he is using. As a result, the code often does not work with the DB you are using. Also, most often,the author only gives code for Access or SQL server, not both, so you spend A LOT of time trying to convert code to get things to work. Lots of times, the author leaves code lines out expecting you to have learned it earlier. If you don't have SQL server, you are going to have a hard time with this book (eval copy is supplied on CD but I couldn't get it to install on win 2000 pro - fortunately I have SQL 7 on another NT 4 machine). Despite these complaints, I am learning a fair amount by persevering and the book does cover quite a bit of material...you just have to spend a lot of time figuring out what he is really doing. Finally, you have to plan to use the complete code supplied on the CD to decipher the text. The text leaves out things that only become clear by extensive examination (and, many times, modification) of the code on the CD. In conclusion, I am finding the book useful and I am learning how to use ADO (author skips DAO etc. as being outdated) but it is more painful than I would like.

8 of 9 people found the following review helpful:

2.0 out of 5 stars Only a basic book for database programming, June 13, 2000

By A Customer

This review is from: Mastering Database Programming with Visual Basic 6 (Paperback)

This truly is only a basic book for the understanding of database programming with vb6. If you want this book to assist you in immediate help in programming vb6 to use databases, then you should look for another one. If you want to use and really become familiar with ADO, then look for another one. It only hits the basics about ADO. It is not for intermediate visual basic progammers, only for the really beginners.