Publisher Description

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 toolsincluding hundreds of efficiencies, step-through wizards, and shortcutsthat 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 6s 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 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 VBs built-in database features
• Get the most out of VBs 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? Dont despair, relax and let Visual Basic 6 Database Programming For Dummies gently ease you into the world of database programming.

Back Cover

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! 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

Flap

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(tm) 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! Download code from this book in the resource area Register to win cool prizes Browse exclusive articles and excerpts Get a free Dummies Daily(tm) e-mail newsletter Chat with authors and preview other books

Author Biography

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 1 Part I: The Basics of Databases 9 Chapter 1: The Big Picture: Visual Basic's Database Features 11 Chapter 2: Databases 101: How Databases Work 19 Part II: Making a Connection 35 Chapter 3: Getting Connected with Data Controls and the Data Form Wizard 37 Chapter 4: Using the Data Environment Designer 53 Chapter 5: A Collection of Connection 71 Part III: Contacting the User 87 Chapter 6: Reports-Plain and Fancy 89 Chapter 7: Designing a User Interface 107 Part IV: Building a New Database 123 Chapter 8: Creating and Manipulating a New Database 125 Chapter 9: Validating and Indexing Your Data 135 Chapter 10: Creating Custom, Data-Bound ActiveX UserControls 147 Part V: The Internet Connection 163 Chapter 11: Translating Windows Applications to Web Pages: Using the ActiveX Document Migration Wizard 165 Chapter 12: Mixing HTML and VB: Active Server Pages 183 Chapter 13: IIS Applications: Moving Beyond ASP 197 Part VI: Hands-On Programming 217 Chapter 14: Doing it Yourself: Data Access Programming 219 Chapter 15: Acronym Soup: ADO, DAO, RDO, UDA 257 Chapter 16: Focus on ADO 265 Chapter 17: Killing Bugs 287 Part VII: Working with Queries 303 Chapter 18: Automatic SQL: Using the Query Designer 305 Chapter 19: A Brief Dictionary of SQL 325 Part VIII: The Part of Tens 347 Chapter 20: Ten Outstanding Add-Ons 349 Chapter 21: Ten Topics that Don't fit Elsewhere in the Book (But Are Important) 353 Index 363 Book Registration Information……Back of Book

Long Description

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, youll 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! 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

Details