Beginning ASP Databases

Description

This book explains, demonstrates, and applies techniques that intersect with two great tools of the information age. The first tool, the database, is relatively old. On the other hand, the second tool, the Internet, is still quite young. And when you pair these tools—voilà! You can create powerful web pages. With the help of Beginning ASP Databases, you will learn to incorporate databases into your ASP applications using ADO (which provides a set of objects that you can connect to, read from, and write to). You'll gain comfort installing necessary software handling stored procedures. And this book will answer many real-world questions, complete with code for you to copy and paste. Content: Front Matter....Pages N2-xx Introduction....Pages 1-8 Why Use ASP and ADO to Put Your Database on the Web?....Pages 11-33 Setting Up ASP and ADO....Pages 35-79 Simple Recordsets — Reading Data....Pages 81-106 Basic SQL for ADO Recordsets....Pages 109-156 More Uses for Simple Recordsets....Pages 159-185 Connections....Pages 187-220 Behind the Scenes of ADO....Pages 223-252 Recordset Parameters....Pages 255-290 RecordSet Methods and Properties....Pages 293-338 SQL Statements To Modify Data....Pages 341-401 Databases and Cookies....Pages 403-433 The Errors Collection....Pages 435-482 Command Object....Pages 485-538 Stored Procedures and Passing Parameters....Pages 541-595 Irregular Data....Pages 597-622 ADO Tips and Tricks....Pages 625-648 Performance Testing and Performance Improvements....Pages 651-678 The Sailors Case Study....Pages 681-739 Back Matter....Pages 741-825