Export (0) Print
Expand All

OdbcParameter Constructor (String, OdbcType, Int32, ParameterDirection, Byte, Byte, String, DataRowVersion, Boolean, Object)

Initializes a new instance of the OdbcParameter class that uses the parameter name, data type, length, source column name, parameter direction, numeric precision, and other properties.

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

public OdbcParameter(
	string parameterName,
	OdbcType odbcType,
	int size,
	ParameterDirection parameterDirection,
	byte precision,
	byte scale,
	string sourceColumn,
	DataRowVersion sourceVersion,
	bool sourceColumnNullMapping,
	Object value
)

Parameters

parameterName
Type: System.String

The name of the parameter.

odbcType
Type: System.Data.Odbc.OdbcType

One of the OdbcType values.

size
Type: System.Int32

The length of the parameter.

parameterDirection
Type: System.Data.ParameterDirection

One of the ParameterDirection values.

precision
Type: System.Byte

The total number of digits to the left and right of the decimal point to which Value is resolved.

scale
Type: System.Byte

The total number of decimal places to which Value is resolved.

sourceColumn
Type: System.String

The name of the source column.

sourceVersion
Type: System.Data.DataRowVersion

One of the DataRowVersion values.

sourceColumnNullMapping
Type: System.Boolean

true if the corresponding source column is nullable; false if it is not.

value
Type: System.Object

An Object that is the value of the OdbcParameter.

ExceptionCondition
ArgumentException

The value supplied in the type parameter is an invalid back-end data type.

The following example creates an OdbcParameter and displays the ParameterName.

public void CreateOdbcParameter() 
{
  OdbcParameter parameter = new OdbcParameter("Description",OdbcType.VarChar,
              11,ParameterDirection.Output,true,0,0,"Description",
              DataRowVersion.Current, false, "garden hose");
  MessageBox.Show(parameter.ToString());
}

.NET Framework

Supported in: 4.5.3, 4, 3.5, 3.0, 2.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

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

Show:
© 2014 Microsoft