Table of Contents:
  • Introduction
  • Why use ASP and ADO to put your database on the Web?
  • Setting up ASP and ADO
  • Simple recordsets - reading data
  • Basic SQL and ADO recordsets
  • More uses for simple recordsets
  • Connections
  • Behind the scenes of ADO
  • Recordset parameters
  • Recordset methods and properties
  • SQL statements to modify data
  • Databases and cookies
  • The errors collection
  • Command object
  • Stored procedures and passing parameters
  • Irregular data
  • ADO tips and tricks
  • Performance testing and performance improvements
  • The sailors case study
  • Appendix A: structure of sailors.mdb
  • Appendix B: structure of clothier.mdb
  • Appendix C: profile.mdb database schema
  • Appendix D: creating a sailors database in SQL server
  • Appendix E: Active server pages object model
  • Appendix F: Microsoft ActiveX data objects 2.0 library reference
  • Appendix G: VBScript reference
  • Index.