OleDbCommandBuilder.DeriveParameters Method (System.Data.OleDb)

DeriveParameters Method

Collapse All

Language Filter

This page is specific to

Microsoft Visual Studio 2008/.NET Framework 3.5

Other versions are also available for the following:

.NET Framework Class Library

OleDbCommandBuilder..::.DeriveParameters Method

Retrieves parameter information from the stored procedure specified in the OleDbCommand and populates the Parameters collection of the specified OleDbCommand object.

Namespace: System.Data.OleDb
Assembly: System.Data (in System.Data.dll)

Syntax

Visual Basic (Declaration)

Public Shared Sub DeriveParameters ( _
    command As OleDbCommand _
)

Visual Basic (Usage)

Dim command As OleDbCommand

OleDbCommandBuilder.DeriveParameters(command)

public static void DeriveParameters(
    OleDbCommand command
)

Visual C++

public:
static void DeriveParameters(
    OleDbCommand^ command
)

JScript

public static function DeriveParameters(
    command : OleDbCommand
)

Parameters

command: Type: System.Data.OleDb..::.OleDbCommand
The OleDbCommand referencing the stored procedure from which the parameter information is to be derived. The derived parameters are added to the Parameters collection of the OleDbCommand.

Exceptions

Exception	Condition
InvalidOperationException	The underlying OLE DB provider does not support returning stored procedure parameter information, the command text is not a valid stored procedure name, or the CommandType specified was not StoredProcedure.

Remarks

DeriveParameters overwrites any existing parameter information for the OleDbCommand.

DeriveParameters requires an additional call to the data source to obtain the information. If the parameter information is known in advance, it is more efficient to populate the parameters collection by setting the information explicitly.

You can only use DeriveParameters with stored procedures. You cannot use DeriveParameters to populate the OleDbParameterCollection with arbitrary Transact-SQL statements, such as a parameterized SELECT statement.

For more information, see Configuring Parameters and Parameter Data Types (ADO.NET).

Platforms

Windows 7, Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Version Information

.NET Framework

Supported in: 3.5, 3.0, 2.0, 1.1, 1.0

Reference

OleDbCommandBuilder Class

OleDbCommandBuilder Members

System.Data.OleDb Namespace

Other Resources

Generating Commands with CommandBuilders (ADO.NET)