Skip to main content
  • Book
  • © 1999

Beginning ASP Databases

Apress
  • Offers an entry point to one of the most crucial aspects of Microsoft-oriented Web development – database integration with Active Server Pages

  • Covers ADO/OLE DB architecture, SQL, recordsets, databases and cookies, error handling, command object, stored procedures, irregular data handling, performance testing and tuning and more

  • Discusses how to incorporate databases into your ASP applications, using ActiveX Data Objects (ADO)

  • Provides code examples, exercises, and quizzes – each captioned with step-by-step explanations

Buy it now

Buying options

eBook USD 29.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 39.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (19 chapters)

  1. Front Matter

    Pages N2-xx
  2. Introduction

    • John Kauffman, Kevin Spencer, Thearon Willis
    Pages 1-8
  3. Why Use ASP and ADO to Put Your Database on the Web?

    • John Kauffman, Kevin Spencer, Thearon Willis
    Pages 11-33
  4. Setting Up ASP and ADO

    • John Kauffman, Kevin Spencer, Thearon Willis
    Pages 35-79
  5. Simple Recordsets — Reading Data

    • John Kauffman, Kevin Spencer, Thearon Willis
    Pages 81-106
  6. Basic SQL for ADO Recordsets

    • John Kauffman, Kevin Spencer, Thearon Willis
    Pages 109-156
  7. More Uses for Simple Recordsets

    • John Kauffman, Kevin Spencer, Thearon Willis
    Pages 159-185
  8. Connections

    • John Kauffman, Kevin Spencer, Thearon Willis
    Pages 187-220
  9. Behind the Scenes of ADO

    • John Kauffman, Kevin Spencer, Thearon Willis
    Pages 223-252
  10. Recordset Parameters

    • John Kauffman, Kevin Spencer, Thearon Willis
    Pages 255-290
  11. RecordSet Methods and Properties

    • John Kauffman, Kevin Spencer, Thearon Willis
    Pages 293-338
  12. SQL Statements To Modify Data

    • John Kauffman, Kevin Spencer, Thearon Willis
    Pages 341-401
  13. Databases and Cookies

    • John Kauffman, Kevin Spencer, Thearon Willis
    Pages 403-433
  14. The Errors Collection

    • John Kauffman, Kevin Spencer, Thearon Willis
    Pages 435-482
  15. Command Object

    • John Kauffman, Kevin Spencer, Thearon Willis
    Pages 485-538
  16. Stored Procedures and Passing Parameters

    • John Kauffman, Kevin Spencer, Thearon Willis
    Pages 541-595
  17. Irregular Data

    • John Kauffman, Kevin Spencer, Thearon Willis
    Pages 597-622
  18. ADO Tips and Tricks

    • John Kauffman, Kevin Spencer, Thearon Willis
    Pages 625-648
  19. Performance Testing and Performance Improvements

    • John Kauffman, Kevin Spencer, Thearon Willis
    Pages 651-678
  20. The Sailors Case Study

    • John Kauffman, Kevin Spencer, Thearon Willis
    Pages 681-739

About this book

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.

About the authors

Kevin Spencer started programming in C in the early 1990s and wrote a number of shareware programs for DOS, most of which were door programs for BBSs. In the process, he learned to construct relational databases in C, and later worked with Microsoft Visual FoxPro and Access. As Internet database connectivity technologies began to emerge from Microsoft, he learned them as well. He then started his own business, Site Design by TAKempis, which specializes in Internet database application programming with ASP/ADO. Microsoft awarded him with the "Most Valuable Professional" award in 1997. He has written articles about Microsoft FrontPage and ASP/ADO for several online magazines, including ASP Today.

Bibliographic Information

  • Book Title: Beginning ASP Databases

  • Authors: John Kauffman, Kevin Spencer, Thearon Willis

  • DOI: https://doi.org/10.1007/978-1-4302-1121-1

  • Publisher: Apress Berkeley, CA

  • eBook Packages: Springer Book Archive

  • Copyright Information: John Kauffman, with Kevin Spencer, and Thearon Willis 1999

  • Softcover ISBN: 978-1-59059-249-6Published: 02 September 2003

  • eBook ISBN: 978-1-4302-1121-1Published: 26 August 2003

  • Edition Number: 1

  • Number of Pages: XX, 856

  • Topics: Database Management, Software Engineering/Programming and Operating Systems

Buy it now

Buying options

eBook USD 29.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 39.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access