CNXParameter

Namespace: | System.Data.CONNX
Description: | The CNXParameter class is used to provide dynamic parameters to an SQL statement.
Constructors | CNXParameter
Description: | This default constructor creates an empty CNXParameter object.
Parameters: | None
CNXParameter
Description: | This constructor accepts a string value containing the parameter name and a CNXDbType value that contains the datatype for the parameter.
Parameters: | ParameterName
Type: | String
Description: | Name of the parameter.
Type
Type: | CNXDbType
Description: | CONNX data type for the parameter.
CNXParameter
Description: | This constructor accepts a string value containing the parameter name, a CNXDbTpe value that contains the data type for the parameter, and an Int value representing the length of the parameter data.
Parameters: | ParameterName
Type: | String
Description: | Name of the parameter.
Type
Type: | CNXDbType
Description: | CONNX data type for the parameter.
Length
Type: | Int
Description: | Size of the parameter.
CNXParameter
Description: | This constructor accepts a string value containing the parameter name, a CNXDbType value that contains the data type for the parameter, an Int value representing the length of the parameter data, and a string value that contains the name of the column to which the parameter is mapped.
Parameters: | ParameterName
Type: | String
Description: | Name of parameter.
Type
Type: | CNXDbType
Description: | CONNX data type for the parameter.
Length
Type: | Int
Description: | Size of the parameter.
SourceColumn
Type: | String
Description: | Name of the column to which the parameter is mapped.
CNXParameter
Description: | This constructor accepts a string containing the parameter name and an object that contains the data for the parameter string value that represents the name of the parameter object that contains the data for the parameter.
Parameters: | ParameterName
Type: | String
Description: | Name of the parameter.
Value
Type: | Object
Description: | Object that contains the data for the parameter.
CNXParameter
Description: | This constructor accepts a string value containing the parameter name, a CNXDbType value that contains the data type for the parameter, and Int value representing the length of the parameter data, and a string value that contains the name of the column to which the parameter is mapped.
Parameters: | ParameterName
Type: | String
Description: | Name of the parameter.
Type
Type: | CNXDbType
Description: | CONNX data type for the parameter.
SourceColumn
Type: | String
Description: | Name of the column to which the parameter is mapped.
CNXParameter
Description: | The constructor accepts a string value containing the parameter name, a CNXDbType value that contains the data type for the parameter, and a data stream object containing the data to be streamed to the data source.
Parameters: | ParameterName
Type: | String
Description: | Name of the parameter.
Type
Type: | CNXDbType
Description: | CONNX data type for the parameter.
DataStream
Type: | System.IO.Stream
Description: | Stream object that contains the parameter data.
Properties: | CNXType
Return Type: | CNXDbType
Description: | The CNXType property specifies the native CONNX data type for the parameter.
CType
Return Type: | Int16
Description: | The CType property contains the native C data type for the parameter.
DbType
Return Type: | DbType
Description: | The DbType property contains the data type for the parameter.
Direction
Return Type: | ParameterDirection
Description: | The Direction property specifies the type of the parameter, whether it is input only, a return value, etc.
IsNullable
Return Type: | Boolean
Description: | The IsNullable property returns a Boolean value if null values are acceptable in the parameter.
ODBCType
Return Type: | Int16
Description: | The ODBCType property contains the native ODBC data type for the parameter.
ParameterName
Return Type: | String
Description: | The Parameter name property is used to specify the name of the parameter.
Precision
Return Type: | Byte
Description: | The Precision property is used to specify the number of decimal places to retain for the given parameter.
Scale
Return Type: | Byte
Description: | The Scale property specifies the default number of decimal places for the parameter date.
Size
Return Type: | Int
Description: | The Size property specifies the length of the parameter data.
SourceColumn
Return Type: | String
Description: | The SourceColumn property is used for the name of the source column that is mapped to the data set. This feature is currently not implemented, but is provided for interface compatibility.
SourceVersion
Return Type: | DataRowVersion
Description: | The SourceVersion property is used to determine if the original or current data is used in the parameter. This feature is currently not implemented, but is provided for interface compatibility.
Stream
Return Type: | System.IO.Stream
Description: | The Stream property accepts a Stream object that can be used to stream Blob and Clob parameter data to the data source.
Value
Return Type: | Object
Description: | The Value property is used to store the data for the parameter.
Methods | GetDBType
Return Type: | DBType
Description: | The GetDBType method returns the DBType of the specified object.
Parameters: | Value
Type: | Object
Description: | Object for which the type will be retrieved.