Database Web Applications
SQL Select Statement
SQL Where Clause
Sort Results Orderby
Modify Records Update
SQL Insert Statement
Delete Table Row
Binding DataBound DesignTime Controls
Scripting with Recordsets
Defensive Programming Handling Errors
Updating Database Records
Data Types Databases
Direct Database Access
Binding Data Bound Time Controls - Exercise
Browse current specials
Create a Web page with a Recordset DTC and bind the recordset to HTML DTCs.
This exercise is worth 10 points.
In this exercise you will add a new page that will be used later to display current VirtualBookShelf.com specials. The page will only display one record at this time. More functionality will be added in later lessons.
Add a new page named Specials.asp to the VirtualBookShelf.com project
Add a Recordset DTC
Name the Recordset DTC BookRecords and set it to reference the BookTable
Add Textbox DTCs for the following fields: ItemNo, Title, Author, and Retail
Submitting your exercise
To submit your results, copy the contents of your Specials.asp page from the PHP source editor and paste them into the textbox below.
When you have finished, just click the
button to receive full credit.