OdbcParameter.DbType Property

Reference

Definition

Namespace:: System.Data.Odbc

Assembly:: System.Data.Odbc.dll

Assembly:: System.Data.dll

Package:: System.Data.Odbc v10.0.0-preview.1.25080.5

Source:: OdbcParameter.cs

Source:: OdbcParameter.cs

Source:: OdbcParameter.cs

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.

Gets or sets the DbType of the parameter.

public:
 virtual property System::Data::DbType DbType { System::Data::DbType get(); void set(System::Data::DbType value); };

public:
 property System::Data::DbType DbType { System::Data::DbType get(); void set(System::Data::DbType value); };

public override System.Data.DbType DbType { get; set; }

[System.ComponentModel.Browsable(false)]
public System.Data.DbType DbType { get; set; }

member this.DbType : System.Data.DbType with get, set

[<System.ComponentModel.Browsable(false)>]
member this.DbType : System.Data.DbType with get, set

Public Overrides Property DbType As DbType

Public Property DbType As DbType

Property Value

DbType

One of the DbType values. The default is String.

Implements

DbType

Attributes: BrowsableAttribute

Exceptions

ArgumentOutOfRangeException

The property was not set to a valid DbType.

Examples

The following example calls a Stored Procedure with three parameters using the ODBC managed provider.

public void CreateMyProc(OdbcConnection connection)
{
    OdbcCommand command = connection.CreateCommand();
    command.CommandText = "{ call MyProc(?,?,?) }";

    OdbcParameter param = new OdbcParameter();
    param.DbType = DbType.Int32;
    param.Value = 1;
    command.Parameters.Add(param);

    param = new OdbcParameter();
    param.DbType = DbType.Decimal;
    param.Value = 1;
    command.Parameters.Add(param);

    param = new OdbcParameter();
    param.DbType = DbType.Decimal;
    param.Value = 1;
    command.Parameters.Add(param);

    command.ExecuteNonQuery();
 }

Public Sub CreateMyProc(ByVal connection As OdbcConnection)

  Dim command As OdbcCommand = connection.CreateCommand()
  Command.CommandText = "{ call MyProc(?,?,?) }"

  Dim param As New OdbcParameter()
  param.DbType = DbType.Int32
  param.Value = 1
  command.Parameters.Add(param)

  param = New OdbcParameter()
  param.DbType = DbType.Decimal
  param.Value = 1
  command.Parameters.Add(param)

  param = New OdbcParameter()
  param.DbType = DbType.Decimal
  param.Value = 1
  command.Parameters.Add(param)

  command.ExecuteNonQuery()

End Sub

Remarks

The OdbcType and DbType are linked. Therefore, setting the DbType changes the OdbcType to a supporting OdbcType.

For a list of the supported data types, see the appropriate OdbcType member. For more information, see DataAdapter Parameters.

Note

Object is not supported by the Microsoft .NET Framework Data Provider for ODBC.

Applies to

Product	Versions
.NET	8 (package-provided), 9 (package-provided), 10 (package-provided)
.NET Framework	1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1
.NET Standard	2.0 (package-provided)

Share via