Download sample
This application demonstrates how to programmatically create and use stored procedures with ADO.NET and Microsoft SQL Server.
.gif) Security Note |
|---|
| This sample code is provided to illustrate a concept and should not be used in applications or Web sites, as it may not illustrate the safest coding practices. Microsoft assumes no liability for incidental or consequential damages should the sample code be used for purposes other than as intended. |
To open the sample file in Solution Explorer
-
Click Download Sample.
The File Download message box appears.
-
Click Open, and on the left column of the zip folder window, click Extract all files.
The Extraction Wizard opens.
-
Click Next. You can change the directory that the files will be extracted to, and then click Next again.
-
Make sure that the Show extracted files check box is selected, and click Finish.
-
Double-click the sample's .sln file.
The sample solution is displayed in Solution Explorer. You might get a security warning that says the solution location is not trusted. Click OK to continue.
To run this sample
Requirements
Demonstrates
The following tasks are demonstrated:
-
Create a new database using SQL commands and resource files to control the scripts to execute. A new database is created with a new table. The table is then populated with additional scripts. An additional script is executed to create the stored procedures used within this sample.
-
Execute a stored procedure that does not require any parameters, using a SqlDataReader object.
-
Execute a stored procedure that requires an input parameter and fill a grid control with the results of a SqlDataAdapter.
-
Execute a stored procedure that requires both input and output parameters and that makes use of a return value.
See Also