Stored Procedure Sample

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

To get samples and instructions for installing them

  • Do one or more of the following:

    • On the Help menu, click Samples.

      The Readme displays information about samples.

    • Visit the Visual Studio 2008 Samples Web site. The most recent versions of samples are available there.

    • Locate samples on the computer on which Visual Studio is installed. By default, samples and a Readme file are installed in drive:\Program Files\Microsoft Visual Studio 9.0\Samples\lcid. For Express editions of Visual Studio, all samples are located online.

For more information, see Visual Studio Samples.

Security noteSecurity Note:

This sample code is intended to illustrate a concept, and it shows only the code that is relevant to that concept. It may not meet the security requirements for a specific environment, and it should not be used exactly as shown. We recommend that you add security and error-handling code to make your projects more secure and robust. Microsoft provides this sample code "AS IS" with no warranties.

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 with a new table is created. The table is then populated with additional scripts. An additional script is executed to create the stored procedures that are used within this sample.

  • Execute a stored procedure that does not require any parameters by 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 uses a return value.

See Also


How to: Create and Execute an SQL Statement that Returns a Single Value

How to: Execute a Stored Procedure that Returns No Value

How to: Install and Troubleshoot Database Components for Samples


Parameters in Data-Adapter Commands

Retrieving Data Using a DataReader (ADO.NET)

TableAdapter Overview

What's New in Data