How Do I...? Common Tasks QuickStart Tutorial

Data and ADO.NET

Get an overview of ADO.NET

Execute a command

Get out parameters from a stored procedure

Populate a DataSet from a Database

Update a database from a DataSet

Read and write XML

Use database transactions

Handle errors

Work with hierarchical or relational data

Work with typed data

Filter data

Use connection pooling

Generate XML with data from SQL Server

Retrieve data from a database Using OLE DB

Retrieve data from a SQLServer database

Migrate from ADO to ADO.NET

ADO.NET: Get Out Parameters from a Stored Procedure

Some stored procedures return values through parameters. When a parameter in a SQL statement or stored procedure is declared as "out", the value of the parameter is returned back to the caller; the value is stored in a parameter in the Parameters collection on the OleDbCommand or SqlCommand objects.

Unlike the sample below, if the connection and command name are not set, you can still establish the parameters, but you have to create the collection of parameters and expected types.

		
    workParam = myCommand.Parameters.Add("@CustomerID", SQLDataType.NChar, 5)
    workParam.Value = "CUSTID"

The following sample shows how to use a stored procedure that returns output parameters. The command is executed to create a stored procedure in the Northwind database.

VB OutParamsWithACommand.aspx