Microsoft created Active Server Pages (ASP) to sew together a group of technologies for creating modern web sites, which can intelligently interact with the user at the front end and with servers and datastores at the back end. Among these technologies is ActiveX Data Objects (ADO), which allows easy, powerful and robust control of technologies that access datastores. This book explains the theory and practice of using ADO with ASP by presenting numerous examples, exercises, lists of common errors and quizzes. The emphasis is on the author's proven teaching techniques and the presentation of the most commonly used features of ADO in ASP. If you read each chapter and do the exercises you will have a portfolio of several dozen data-intensive web pages of increasing complexity - a fine return on your investment. What Is This Book About? This book explains, demonstrates and applies techniques that lie at the intersection of the two great tools of the Information Age. One tool, the database, is relatively old. The other, the World Wide Web, is quite new. ASP and ADO together provide the ability to combine these two to maximum effect. Even the most computer-illiterate managers realize that business as we know it today could not exist without databases to hold information on customers, orders, inventory, accounts, payroll and every other facet of commercial activity. Many of the great advances in productivity since 1960 have been possible because of the speed and accuracy that databases provide for business information.
Chapter 1: Why Use ASP and ADO to put your Database on the Web? Chapter 2: Setting Up ASP and ADO Chapter 3: Simple Recordsets - Reading Data Chapter 4: Basic SQL for ADO Recordsets Chapter 5: More Uses for Simple Recordsets Chapter 6: Connections Chapter 7: Behind the Scenes of ADO Chapter 8: Recordset Parameters Chapter 9: Recordset Methods and Properties Chapter 10: SQL Statements to Modify Data Chapter 11: Databases and Cookies Chapter 12: The Errors Collection Chapter 13: Command Object Chapter 14: Stored Procedures and Passing Parameters Chapter 15: Irregular Data Chapter 16: ADO Tips and Tricks Chapter 17: Performance Testing and Performance Improvements