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. | ||