SQLConfiguration SQLConfiguration

Modifying Data  «Prev  Next»
Lesson 4Deleting Records
Objective Use the recordset object to delete records.

Deleting Database Records

The VirtualBookShelf application will need the capability to remove records from the database. Some books will no longer be carried in inventory and customers will be deleted after some period of inactivity. You will want to remove these from the database to get rid of unnecessary data and to reduce storage space.
Just as you have seen in the lessons for updating and inserting records, Visual Studio makes it very easy to add delete capability. The following simulation takes you through the steps for adding a Delete button to CustManage.asp:
Deleting Records using Recordset Object
In the next lesson, you will learn to coerce scripting data types to match database types.