OdbcParameter.DbType Property

 

Gets or sets the DbType of the parameter.

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

public override DbType DbType { get; set; }

Property Value

Type: System.Data.DbType

One of the DbType values. The default is String.

Exception Condition
ArgumentOutOfRangeException

The property was not set to a valid DbType.

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.

System_CAPS_noteNote

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

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

 }

.NET Framework
Available since 1.1
Return to top
Show: