OdbcParameter Constructors

Reference

Definition

Namespace:: System.Data.Odbc

Assembly:: System.Data.Odbc.dll

Assembly:: System.Data.dll

Package:: System.Data.Odbc v9.0.0

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

Source:: OdbcParameter.cs

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.

Applies to

OdbcParameter(String, OdbcType)

Source:: OdbcParameter.cs

Source:: OdbcParameter.cs

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

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

Applies to

OdbcParameter(String, Object)

Source:: OdbcParameter.cs

Source:: OdbcParameter.cs

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

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.

Applies to

OdbcParameter(String, OdbcType, Int32)

Source:: OdbcParameter.cs

Source:: OdbcParameter.cs

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

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

Applies to

OdbcParameter(String, OdbcType, Int32, String)

Source:: OdbcParameter.cs

Source:: OdbcParameter.cs

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

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

Applies to

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

Source:: OdbcParameter.cs

Source:: OdbcParameter.cs

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

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

Applies to

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

Source:: OdbcParameter.cs

Source:: OdbcParameter.cs

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

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

Applies to

共用方式為

OdbcParameter Constructors

Definition

Overloads

OdbcParameter()

Examples

Remarks

See also

Applies to

OdbcParameter(String, OdbcType)

Parameters

Exceptions

Examples

See also

Applies to

OdbcParameter(String, Object)

Parameters

Remarks

See also

Applies to

OdbcParameter(String, OdbcType, Int32)

Parameters

Exceptions

Examples

See also

Applies to

OdbcParameter(String, OdbcType, Int32, String)

Parameters

Exceptions

Examples

See also

Applies to

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

Parameters

Exceptions

Examples

See also

Applies to

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

Parameters

Exceptions

Examples

See also

Applies to

其他資源