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

 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

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.

Exception Condition
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
Available since 2.0
Return to top
Show: