OdbcParameter Constructor (String, OdbcType, Int32, ParameterDirection, Boolean, Byte, Byte, String, DataRowVersion, 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,
	bool isNullable,
	byte precision,
	byte scale,
	string srcColumn,
	DataRowVersion srcVersion,
	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.

isNullable
Type: System.Boolean

true if the value of the field can be null; otherwise false.

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.

srcColumn
Type: System.String

The name of the source column.

srcVersion
Type: System.Data.DataRowVersion

One of the DataRowVersion values.

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, "garden hose");
    Console.WriteLine(parameter.ToString());
}

.NET Framework
Available since 1.1
Return to top
Show: