- - - -
- - - -
|
Chapter 10 - Readme
Chapter 10 Errata Pages
The examples in this chapter were created with Visual Basic 6.0.
You can register and use the compiled ASP components directly, or you can open the
projects and re-build the objects before registering. You do not have to re-compile the components if you don't wish to; you can, instead,
use regsvr32.exe to register the components and run the tests directly.
All the code, components and forms, to provide full CRUD (Create Read Update Delete) of
authors, titles, and publishers is included with downloadable code. The SQL for the
examples is in books.sql. Examples have been tested with SQL Server 6.5 and
SQL Server 7.0, with ADO 2.0 and ADO 2.1.
Example to Chapter Mapping |
The ASP page access.asp is the entry page to the entire system. This page will list all of the
authors, publishers, and book titles, and allow you to Add, Delete, or View (and Update) a specific author,
publisher, or book title. You must register all three of the DLLs included with this chapter: Authors.dll, Publishers.dll,
and Titles.dll, before accessing access.asp.
|
Example 10-1 and 10-2, Using returned Recordset | Component is Authors.dll, method is getAuthors2 page is first.asp |
Example 10-3 through 10-7, Using a stored procedure and demonstrating different techniques to process data | Component is Authors.dll, pages are second.asp and authors1.asp |
Example 10-8 and 10-9, Updating multiple tables - using datasets for list population | Component is Authors.dll, pages are titles.asp and addtitle.asp
Additionally, supporting changes are: New component, Publishers.dll, with test page of publishers.asp, and a new function for Titles.dll |
Example 10-10, A Simple Insert | Component is Authors.dll, pages are authors.asp and addauthor.asp |
Example 10-11 through 10-13,Deletions and referential integrity | Component is Titles.dll, pages are access.asp and deltitle.asp
|
Example 10-14 through 10-15, before and after comparison update | Component is Authors.dll, pages are access.asp and vauthors.asp and updtauthor.asp
|
For more information
|