Export (0) Print
Expand All

OdbcCommand.Prepare Method

Creates a prepared or compiled version of the command at the data source.

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

public override void Prepare()

Implements

IDbCommand.Prepare()

ExceptionCondition
InvalidOperationException

The Connection is not set.

-or-

The Connection is not [!:System.Data.Odbc.OdbcConnection.Open].

The Prepare method calls the ODBC SQLPrepare function. Depending on the capabilities of the underlying ODBC driver and data source, parameter information such as data types may be checked when the statement is prepared, if all parameters have been bound, or when it is executed if not all parameters have been bound. For maximum interoperability, an application should unbind all parameters that applied to a previous SQL statement before preparing a new SQL statement on the same OdbcCommand. This prevents errors that are caused by previous parameter information being applied to the new SQL statement.

If you call an Execute method after you call Prepare, any parameter value that is larger than the value specified by the [!:System.Data.Odbc.OdbcParameter.Size] property is automatically truncated to the original specified size of the parameter, and no truncation errors are returned.

Output parameters (whether prepared or not) must have a user-specified data type. If you specify a variable length data type, you must also specify the maximum [!:System.Data.Odbc.OdbcParameter.Size].

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.

.NET Framework

Supported in: 3.5, 3.0, 2.0, 1.1

Community Additions

ADD
Show:
© 2015 Microsoft