The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

Stored Procedure Sample 

Download sample

This application demonstrates how to programmatically create and use stored procedures with ADO.NET and Microsoft SQL Server.

Security noteSecurity 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

  1. Click Download Sample.

    The File Download message box appears.

  2. Click Open, and on the left column of the zip folder window, click Extract all files.

    The Extraction Wizard opens.

  3. Click Next. You can change the directory that the files will be extracted to, and then click Next again.

  4. Make sure that the Show extracted files check box is selected, and click Finish.

  5. 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

  • Press F5.


This sample requires the Northwind sample database. For more information, see How to: Install and Troubleshoot Database Components for Samples.


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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft