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.
.gif "Security note") Security 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.
Requirements
This sample requires the Northwind sample database. For more information, see How to: Install and Troubleshoot Database Components for Samples.
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 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
Tasks
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
Concepts
Parameters in Data-Adapter Commands