Visual Basic 6 Database Programming For Dummies

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