OdbcParameter Constructors

Definition

Namespace:

System.Data.Odbc

Assembly:

System.Data.Odbc.dll

Package:

System.Data.Odbc v9.0.0-rc.2.24473.5

Initializes a new instance of the OdbcParameter class.

Overloads

OdbcParameter()	Initializes a new instance of the OdbcParameter class.
OdbcParameter(String, OdbcType)	Initializes a new instance of the OdbcParameter class that uses the parameter name and data type.
OdbcParameter(String, Object)	Initializes a new instance of the OdbcParameter class that uses the parameter name and an OdbcParameter object.
OdbcParameter(String, OdbcType, Int32)	Initializes a new instance of the OdbcParameter class that uses the parameter name, data type, and length.
OdbcParameter(String, OdbcType, Int32, String)	Initializes a new instance of the OdbcParameter class that uses the parameter name, data type, length, and source column name.
OdbcParameter(String, OdbcType, Int32, ParameterDirection, Boolean, Byte, Byte, String, DataRowVersion, 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.
OdbcParameter(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.

OdbcParameter()

Source:

OdbcParameter.cs

Initializes a new instance of the OdbcParameter class.

public:
 OdbcParameter();

public OdbcParameter ();

Public Sub New ()

Examples

The following example creates an OdbcParameter and sets some of its properties.

public void CreateOdbcParameter()
{
   OdbcParameter parameter = new OdbcParameter();
   parameter.ParameterName = "Description";
   parameter.OdbcType = OdbcType.VarChar;
   parameter.Direction = ParameterDirection.Output;
   parameter.Size = 88;
}

Public Sub CreateOdbcParameter()
    Dim parameter As New OdbcParameter()
    parameter.ParameterName = "Description"
    parameter.OdbcType = OdbcType.VarChar
    parameter.Direction = ParameterDirection.Output
    parameter.Size = 88
End Sub

Remarks

The base constructor initializes all fields to their default values.

See also

• Working with Commands

OdbcParameter(String, OdbcType)

Source:

OdbcParameter.cs

Initializes a new instance of the OdbcParameter class that uses the parameter name and data type.

public:
 OdbcParameter(System::String ^ name, System::Data::Odbc::OdbcType type);

public OdbcParameter (string? name, System.Data.Odbc.OdbcType type);

new System.Data.Odbc.OdbcParameter : string * System.Data.Odbc.OdbcType -> System.Data.Odbc.OdbcParameter

Public Sub New (name As String, type As OdbcType)

Parameters

name

String

The name of the parameter.

type

OdbcType

One of the OdbcType values.

Exceptions

ArgumentException

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

Examples

The following example creates an OdbcParameter and sets some of its properties.

public void CreateOdbcParameter()
{
   OdbcParameter parameter = new OdbcParameter("Description",OdbcType.VarChar);
   parameter.Direction = ParameterDirection.Output;
   parameter.Size = 88;
}

Public Sub CreateOdbcParameter()
    Dim parameter As New OdbcParameter("Description", OdbcType.VarChar)
    parameter.Direction = ParameterDirection.Output
    parameter.Size = 88
End Sub

See also

• Working with Commands

OdbcParameter(String, Object)

Source:

OdbcParameter.cs

Initializes a new instance of the OdbcParameter class that uses the parameter name and an OdbcParameter object.

public:
 OdbcParameter(System::String ^ name, System::Object ^ value);

public OdbcParameter (string? name, object? value);

new System.Data.Odbc.OdbcParameter : string * obj -> System.Data.Odbc.OdbcParameter

Public Sub New (name As String, value As Object)

Parameters

name

String

The name of the parameter.

value

Object

An OdbcParameter object.

Remarks

Use caution when you are using this overload of the OdbcParameter constructor to specify integer parameter values. Because this overload takes a value of type Object, you must convert the integral value to an Object type when the value is zero, as the following C# example demonstrates.

Parameter = new OdbcParameter("@pname", Convert.ToInt32(0));  

If you do not perform this conversion, the compiler assumes that you are trying to call the OdbcParameter.OdbcParameter constructor overload.

See also

• Working with Commands

OdbcParameter(String, OdbcType, Int32)

Source:

OdbcParameter.cs

Initializes a new instance of the OdbcParameter class that uses the parameter name, data type, and length.

public:
 OdbcParameter(System::String ^ name, System::Data::Odbc::OdbcType type, int size);

public OdbcParameter (string? name, System.Data.Odbc.OdbcType type, int size);

new System.Data.Odbc.OdbcParameter : string * System.Data.Odbc.OdbcType * int -> System.Data.Odbc.OdbcParameter

Public Sub New (name As String, type As OdbcType, size As Integer)

Parameters

name

String

The name of the parameter.

type

OdbcType

One of the OdbcType values.

size

Int32

The length of the parameter.

Exceptions

ArgumentException

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

Examples

The following example creates an OdbcParameter and sets some of its properties.

public void CreateOdbcParameter()
{
   OdbcParameter parameter = new OdbcParameter("Description",OdbcType.VarChar,88);
   parameter.Direction = ParameterDirection.Output;
}

Public Sub CreateOdbcParameter()
    Dim parameter As New OdbcParameter("Description", OdbcType.VarChar, 88)
    parameter.Direction = ParameterDirection.Output
End Sub

See also

• Working with Commands

OdbcParameter(String, OdbcType, Int32, String)

Source:

OdbcParameter.cs

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

public:
 OdbcParameter(System::String ^ name, System::Data::Odbc::OdbcType type, int size, System::String ^ sourcecolumn);

public OdbcParameter (string? name, System.Data.Odbc.OdbcType type, int size, string? sourcecolumn);

new System.Data.Odbc.OdbcParameter : string * System.Data.Odbc.OdbcType * int * string -> System.Data.Odbc.OdbcParameter

Public Sub New (name As String, type As OdbcType, size As Integer, sourcecolumn As String)

Parameters

name

String

The name of the parameter.

type

OdbcType

One of the OdbcType values.

size

Int32

The length of the parameter.

sourcecolumn

String

The name of the source column.

Exceptions

ArgumentException

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

Examples

The following example creates an OdbcParameter and sets some of its properties.

public void CreateOdbcParameter()
{
    OdbcParameter parameter = new OdbcParameter("Description",OdbcType.VarChar,
        88,"Description");
    parameter.Direction = ParameterDirection.Output;
}

Public Sub CreateOdbcParameter()
    Dim parameter As New OdbcParameter("Description", OdbcType.VarChar, 88, "Description")
    parameter.Direction = ParameterDirection.Output
End Sub

See also

• Working with Commands

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

Source:

OdbcParameter.cs

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.

public:
 OdbcParameter(System::String ^ parameterName, System::Data::Odbc::OdbcType odbcType, int size, System::Data::ParameterDirection parameterDirection, bool isNullable, System::Byte precision, System::Byte scale, System::String ^ srcColumn, System::Data::DataRowVersion srcVersion, System::Object ^ value);

public OdbcParameter (string? parameterName, System.Data.Odbc.OdbcType odbcType, int size, System.Data.ParameterDirection parameterDirection, bool isNullable, byte precision, byte scale, string? srcColumn, System.Data.DataRowVersion srcVersion, object? value);

new System.Data.Odbc.OdbcParameter : string * System.Data.Odbc.OdbcType * int * System.Data.ParameterDirection * bool * byte * byte * string * System.Data.DataRowVersion * obj -> System.Data.Odbc.OdbcParameter

Public Sub New (parameterName As String, odbcType As OdbcType, size As Integer, parameterDirection As ParameterDirection, isNullable As Boolean, precision As Byte, scale As Byte, srcColumn As String, srcVersion As DataRowVersion, value As Object)

Parameters

parameterName

String

The name of the parameter.

odbcType

OdbcType

One of the OdbcType values.

size

Int32

The length of the parameter.

parameterDirection

ParameterDirection

One of the ParameterDirection values.

isNullable

Boolean

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

precision

Byte

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

scale

Byte

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

srcColumn

String

The name of the source column.

srcVersion

DataRowVersion

One of the DataRowVersion values.

value

Object

An Object that is the value of the OdbcParameter.

Exceptions

ArgumentException

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

Examples

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());
}

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

See also

• Working with Commands

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

Source:

OdbcParameter.cs

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.

public:
 OdbcParameter(System::String ^ parameterName, System::Data::Odbc::OdbcType odbcType, int size, System::Data::ParameterDirection parameterDirection, System::Byte precision, System::Byte scale, System::String ^ sourceColumn, System::Data::DataRowVersion sourceVersion, bool sourceColumnNullMapping, System::Object ^ value);

public OdbcParameter (string? parameterName, System.Data.Odbc.OdbcType odbcType, int size, System.Data.ParameterDirection parameterDirection, byte precision, byte scale, string? sourceColumn, System.Data.DataRowVersion sourceVersion, bool sourceColumnNullMapping, object? value);

new System.Data.Odbc.OdbcParameter : string * System.Data.Odbc.OdbcType * int * System.Data.ParameterDirection * byte * byte * string * System.Data.DataRowVersion * bool * obj -> System.Data.Odbc.OdbcParameter

Public Sub New (parameterName As String, odbcType As OdbcType, size As Integer, parameterDirection As ParameterDirection, precision As Byte, scale As Byte, sourceColumn As String, sourceVersion As DataRowVersion, sourceColumnNullMapping As Boolean, value As Object)

Parameters

parameterName

String

The name of the parameter.

odbcType

OdbcType

One of the OdbcType values.

size

Int32

The length of the parameter.

parameterDirection

ParameterDirection

One of the ParameterDirection values.

precision

Byte

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

scale

Byte

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

sourceColumn

String

The name of the source column.

sourceVersion

DataRowVersion

One of the DataRowVersion values.

sourceColumnNullMapping

Boolean

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

value

Object

An Object that is the value of the OdbcParameter.

Exceptions

ArgumentException

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

Examples

The following example creates an OdbcParameter and displays the ParameterName.

Public Sub CreateOdbcParameter()  
  Dim parameter As New OdbcParameter("Description", OdbcType.VarChar, 11, ParameterDirection.Output, True, 0, 0, "Description", DataRowVersion.Current, False, "garden hose")  
  MessageBox.Show(parameter.ToString())  
End Sub  

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());  
}  

See also

• Working with Commands