Running the stored procedure in ASP.NET With ASP.NET pages in , you must add a Stored Procedure server behavior to a page to execute a stored procedure.
To add a stored procedure to a ASP.NET page:
In , open the page that will run the stored procedure.
In the Bindings panel, click the plus (+) button, and then select Stored Procedure.
The Stored Procedure dialog box appears.
Complete the dialog box.
For more information, see Setting the Stored Procedure dialog box options.
Click OK.
After you close the dialog box, inserts ASP.NET code in your page
that, when run on the server, executes a stored procedure in the database. The
stored procedure in turn performs a database operation, such as inserting a
record or executing a query.
If the stored procedure takes parameters, you might create a page that gathers the parameter values and submits them to the page with the stored procedure. For example, you may create a page that uses URL parameters or an HTML form to gather parameter values from users.
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