RelationalDBDesign
SiteMap
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Database Web Apps
Data Manipulation
Access Features
Tables Queries
Data Access
«Prev
Next»
Database Web Applications
Database Concepts
Table Structures
SQL
Data Binding
Basic Queries
SQL Select Statement
SQL Where Clause
Sort Results Orderby
Modify Records Update
SQL Insert Statement
Delete Table Row
SQL Capability Conclusion
Data Access
Binding DataBound DesignTime Controls
Scripting with Recordsets
Defensive Programming Handling Errors
Modifying Data
Updating Database Records
Data Types Databases
Direct Database Access
Binding Data Bound Time Controls - Exercise
Browse current Specials
Objective:
Create a Web page with a Recordset DTC and bind the recordset to HTML DTCs.
Exercise scoring:
This exercise is worth 10 points.
Background/overview
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.
Instructions
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
Submit
button to receive full credit.
Submit