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 Internet, is quite new. With these two tools together, readers can create powerful Web pages. In this book, readers will learn how to incorporate databases into their ASP applications using ADO, which provides a set of objects through which one can connect to, read from, and write to databases. From installing the necessary software and a basic guide to SQL, to handling stored procedures, readers will get several real-world questions answered with code ready to cut and paste and a chance to practice at every step of the way.

Table of Contents

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