Synopses & Reviews
While previous versions of Visual Basic had some database facilities, with Visual Basic 6, Microsoft has created a robust, fully-fledged database programming language. VB6 includes a raft of highly effective database features and tools?including hundreds of efficiencies, step-through wizards, and shortcuts?that in most cases are extremely easy to understand and master. Among the most important of these are ADO Data Control, Data View window, Query Designer, DataRepeater Control, Data Environment Designer, ActiveX Document Migration Wizard, WebClass Designer, and Visual Data Manager.
Visual Basic 6 Database Programming For Dummies is a friendly, no-nonsense guide for programmers already familiar with Visual Basic who want to take advantage of all of version 6?s powerful database features. Packed with real-world examples and plain-English explanations, it cuts through the jargon and shows you, step-by-step, how to:
- Build professional-looking database programs
- Move Windows applications to an intranet or the Internet
- Craft user-friendly interfaces and robust reports
- Automate programming with built-in tools
- Maximize Internet connectivity with ActiveX
- Develop ASP and IIS applications
- Transitions from DAO to ADO
- Understand how best to use all of VB?s built-in database features
- Get the most out of VB?s Data Environment Designer
- Know ho to use SQL
Author Richard Mansfield gives you a solid understanding of what databases are, how they work, and what you can do with them. Then he walks you through all the steps to creating powerful database applications. Topics covered include:
- Getting connected with data controls and the Data Form Wizard
- Using the Data Environment Designer
- Designing a user interface
- Building a new database from scratch
- Translating Windows applications to Web pages using ActiveX Document Migration Wizard
- Combining HTML and VB to create active server pages
- Creating IIS applications
- Data access programming
- Using the Query Designer
Have you been baffled by the alphabet soup of VB6 acronyms? Have you tried other books on the subject and found them sourly lacking in clarity? Don?t despair, relax and let Visual Basic 6 Database Programming For Dummies gently ease you into the world of database programming.
Synopsis
This book introduces programmers to quick database solutions with Visual Basic 6, providing step-by-step instructions on how to design and build databases from scratch using Visual Data Manager and Object Wizard. Elements of database management also are explained, along with other useful tools for VB6.
Synopsis
Packed with proven, step-by-step programming techniques
Hands-on tips for maximizing the powerful VB6 database tools
Create high-performance database applications starting today! Packed with real-world examples and plain-English explanations, this friendly guide cuts through the jargon and shows you step-by-step how to create powerful database applications in Visual Basic 6. From designing interfaces and reports to providing Web access, you'll soon be programming like a database pro!
Discover how to: Craft user-friendly interfaces and robust reports Automate programming with built-in tools Maximize Internet connectivity with ActiveX Develop ASP and IIS applications Transition from DAO to ADO
The Dummies Way Explanations in plain English "Get in, get out" information Icons and other navigational aids Tear-out cheat sheet Top ten lists A dash of humor and fun
Get smart! www.dummies.com Download code from this book in the resource area Register to win cool prizes Browse exclusive articles and excerpts Get a free Dummies Daily e-mail newsletter Chat with authors and preview other books
About the Author
Richard Mansfield, the former editor of Compute! magazine, is the author of more than 20 computer book bestsellers, including Visual Studio 6 For Dummies and Visual InterDev Bible. Nickolas Landry, who supplied the technical review, is an MCSD and a Microsoft Regional Director.
Table of Contents
Introduction.
PART I: The Basics of Databases.
Chapter 1: The Big Picture: Visual Basic's Database Features.
Chapter 2: Databases 101: How Databases Work.
PART II: Making a Connection.
Chapter 3: Getting Connected with Data Controls and the Data Form Wizard.
Chapter 4: Using the Data Environment Designer.
Chapter 5: A Collection of Connections.
PART III: Contacting the User.
Chapter 6: Reports -- Plain and Fancy.
Chapter 7: Designing a User Interface.
PART IV: Building a New Database.
Chapter 8: Creating and Manipulating a New Database.
Chapter 9: Validating and Indexing Your Data.
Chapter 10: Creating Custom, Data-Bound ActiveX UserControls.
PART V: The Internet Connection.
Chapter 11: Translating Windows Applications to Web Pages: Using the ActiveX Document Migration Wizard.
Chapter 12: Mixing HTML and VB: Active Server Pages.
Chapter 13: IIS Applications: Moving Beyond ASP.
PART VI: Hands-On Programming.
Chapter 14: Doing It Yourself: Data Access Programming.
Chapter 15: Acronym Soup: ADO, DAO, RDO, UDA.
Chapter 16: Focus on ADO.
Chapter 17: Killing Bugs.
PART VII: Working with Queries.
Chapter 18: Automatic SQL: Using the Query Designer.
Chapter 19: A Brief Dictionary of SQL.
PART VIII: The Part of Tens.
Chapter 20: Ten Outstanding Add-Ons.
Chapter 21: Ten Topics that Don't Fit Elsewhere in the Book (But Are Important).
Index.
Book Registration Information.