Beginning ASP Databases

The description below is the publishers own description.

Title: Beginning ASP Databases ISBN: 1861002726 Pub Date: September 1999 Pages: 825

Book Overview

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 authors’ 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's Great About this Book

• Coaches beginners through their first uses of ADO on ASP pages
• All the examples in the book can be applied to real world problems and scenarios and each chapter ends with exercises helping you refine coding skills
• Features troubleshooting check lists of common errors and problems
• Covers basic SQL - from the selection and sorting of records to handling SQL statements and modifying data
• Shows how ADO can streamline data-access for websites
• Covers the full ADO object model

Who is the Book For?

• Readers of Beginning Active Server Pages 2.0 who want to make the next logical step and connect web sites to datastores
• Programmers from the database community who now want to implement their solutions with a Web interface. These folks have plenty of experience with database programming, but want to translate that knowledge into ADO solutions in ASP pages
• Web designers with an education in graphics design or word processing and some sense of programming. These people can benefit from the book by learning how to take their visually appealing sites and give them the business power of database connectivity

Summary of Contents

Introduction 
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 
Case Study: 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

View Sample Chapter

Buy this book at Amazon USA

Buy this book at Amazon UK

Jump to: Top of Page or HOME or Printer friendly page

Search W3Schools:

What Others Say About Us

Does the world know about us? Check out these places:

Dogpile Alta Vista MSN Google Excite Lycos Yahoo Ask Jeeves

We Help You For Free. You Can Help Us!

• Tell your newsgroup or mailing list
• Link to us from your pages
• Help us correct errors and broken links
• Help us with spelling and grammar
• Validate the XHTML code of this page

W3Schools is for training only. We do not warrant its correctness or its fitness for use. The risk of using it remains entirely with the user. While using this site, you agree to have read and accepted our terms of use and privacy policy.

Copyright 1999-2002 by Refsnes Data. All Rights Reserved

How we converted to XHTML