Setting the Delete Record dialog box options (ASP.NET)

The purpose of this dialog box is to add a server behavior to a page containing an HTML form so that users can delete a record in a database table when they click the Submit button on the form.

To set the dialog box options:

1. In the First Check If Variable Is Defined pop-up menu, select Primary Key Value.

   If you want to check a variable other than the variable identifying the record to delete, then select the variable and enter its name.

   Dreamweaver checks to see if that variable is defined.

2. In the Connection pop-up menu, select a connection so that the page can find and connect to the database.

   Click the Define button if you need to define a connection.

3. In the Table pop-up menu, select the database table containing the records to delete.
4. In the Primary Key Column pop-up menu, select a key column to identify the record in the database table.
5. In the Submit Primary Key As pop-up menu, select a data type.

   The data type is the kind of data the column in your database table is expecting (text, numeric, Boolean checkbox values).

6. In the Primary Key Value pop-up menu, select the variable identifying the record to delete, and then enter its name.
7. In the On Success, Go To text box, enter the location of a page to display if the deletion is successful or click the Browse button to browse to the location.
8. In the On Failure, Go To text box, enter the location of a page to display if the deletion fails or click the Browse button to browse to the location.
9. Select the Display Debugging Information on Failure checkbox if you want debugging information when the deletion fails.

   When you select this option, Dreamweaver ignores the On Failure, Go To option.

   TIP

   Use the debugging option during development and use the On Failure, Go To option when your site is live.

10. Click OK.

Dreamweaver adds a server behavior to the page that lets users delete records in a database table by clicking the Submit button on the form.