Setting the Stored Procedure dialog box options (ASP.NET)

Setting the Stored Procedure dialog box options (ASP.NET)

The purpose of this dialog box is to set up your ASP.NET page to use a stored procedure.

To set the dialog box options:

  1. Enter a name for the stored procedure.
  2. In the Connection pop-up menu, select a connection to the database containing the stored procedure.

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

  3. Select a stored procedure from the Procedures pop-up menu.

    Dreamweaver automatically fills in any parameters.

  4. Select the Returns DataSet checkbox if the stored procedure returns a DataSet, and then click the Test button to see the DataSet the stored procedure returns.
  5. Select a parameter, then click the Edit button if you need to make changes or click the Delete button to delete the parameter.

    For more information, see Setting the Edit Stored Procedure Variable dialog box options (ASP.NET).

  6. In the On Success, Go To text box, enter the location of a page to display after the stored procedure runs successfully or click the Browse button to browse to the location.
  7. In the On Failure, Go To text box, enter the location of a page to display if the stored procedure fails or click the Browse button to browse to the location.
  8. Select the Display Debugging Information on Failure checkbox if you want debugging information when the stored procedure fails.

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

  9. Click OK.

After you close the Stored Procedure dialog box, Dreamweaver inserts ASP.NET code in your page that, when run on the server, calls a stored procedure in the database. The stored procedure in turn performs a database operation, such as inserting a record.

Related topics

  • Stored procedures
  • Using stored procedures to modify databases (ASP.NET)


Getting Started with Dreamweaver
Dreamweaver Basics
Working with Dreamweaver Sites
Laying Out Pages
Adding Content to Pages
Working with Page Code
Preparing to Build Dynamic Sites
Making Pages Dynamic
Developing Applications Rapidly
Building ColdFusion Applications Rapidly
Building ASP.NET Applications Rapidly
Reference
Building ASP and JSP Applications Rapidly
 
ASPTreeView.com
 
Evaluation has БВХКШЗАХexpired.
Info...