Setting Stored Procedure Variable dialog box options The purpose of this dialog box is to add or edit stored procedure parameters.
Procedure
The name of the variable you are editing appears in the Name field.
Select a Direction from the pop-up menu.
A stored procedure might have input values, output values, or both input and
output values.
Select an SQL type from the pop-up menu.
Enter a return variable.
Enter a runtime value.
Enter a test value.
Setting the Stored Procedure dialog box options
The purpose of this dialog box is to insert a stored procedure into your ASP.NET
page.
Procedure
Enter a name for the stored procedure.
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.
Select a stored procedure from the Procedures pop-up menu.
automatically fills in any parameters.
Select the Returns DataSet checkbox if the stored procedure returns a recordset,
and then click the Test button to see the recordset the stored procedure returns.
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 Edit Stored Procedure Variable dialog box
options.
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.
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.
Select the Display Debugging Information on Failure checkbox if you want debugging
information when the stored procedure fails.
When you select this option, ignores the On Failure, Go To option.
Tip: Use the debugging option during development, and then use the On Failure, Go To option when your site is live.
Click OK.
After you close the Stored Procedure dialog box, 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.
1 2 3 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 422