Value Property

The value of the parameter.

Syntax

object Value

Access

Read-write

Implements

IDataParameter.Value

Usage

  • For input parameters, the value is bound to the AseCommand that is sent to the server. For output and return value parameters, the value is set on completion of the AseCommand and after the AseDataReader is closed.

  • When sending a null parameter value to the server, the user must specify DBNull, not null: the null value in the system is an empty object that has no value.

  • If the application specifies the database type, the bound value is converted to that type when Adaptive Server ADO.NET Data Provider sends the data to the server. Adaptive Server ADO.NET Data Provider attempts to convert any type of value if it supports the IConvertible interface. Conversion errors can result if the specified type is not compatible with the value.

  • Both the DbType and AseDbType properties can be inferred by setting the Value.

  • The Value property is overwritten by Update.