OleDbParameter Constructor (String, OleDbType, Int32, ParameterDirection, Boolean, Byte, Byte, String, DataRowVersion, Object)

 

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

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

Public Sub New (
	parameterName As String,
	dbType As OleDbType,
	size As Integer,
	direction As ParameterDirection,
	isNullable As Boolean,
	precision As Byte,
	scale As Byte,
	srcColumn As String,
	srcVersion As DataRowVersion,
	value As Object
)

Parameters

parameterName
Type: System.String

The name of the parameter.

dbType
Type: System.Data.OleDb.OleDbType

One of the OleDbType values.

size
Type: System.Int32

The length of the parameter.

direction
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 OleDbParameter.

Exception Condition
ArgumentException

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

The Size and Precision are inferred from the value of the dataType parameter if they are not explicitly set in the size and precision parameters.

The following example creates an OleDbParameter and displays the ParameterName.

Public Sub CreateOleDbParameter()
    Dim parameter As New OleDbParameter( _
        "Description", OleDbType.VarChar, 11, _
        ParameterDirection.Output, True, 0, 0, _
        "Description", DataRowVersion.Current, "garden hose")
    Console.WriteLine(parameter.ToString())
End Sub

.NET Framework
Available since 1.1
Return to top
Show: