SqlParameter Constructor (String^, SqlDbType, Int32, ParameterDirection, Boolean, Byte, Byte, String^, DataRowVersion, Object^)
Initializes a new instance of the SqlParameter class that uses the parameter name, the type of the parameter, the size of the parameter, a ParameterDirection, the precision of the parameter, the scale of the parameter, the source column, a DataRowVersion to use, and the value of the parameter.
Assembly: System.Data (in System.Data.dll)
public: SqlParameter( String^ parameterName, SqlDbType dbType, int size, ParameterDirection direction, bool isNullable, unsigned char precision, unsigned char scale, String^ sourceColumn, DataRowVersion sourceVersion, Object^ value )
Parameters
- parameterName
-
Type:
System::String^
The name of the parameter to map.
- dbType
-
Type:
System.Data::SqlDbType
One of the SqlDbType values.
- size
-
Type:
System::Int32
The length of the parameter.
- direction
-
Type:
System.Data::ParameterDirection
One of the ParameterDirection values.
- isNullable
-
Type:
System::Boolean
true if the value of the field can be null; otherwise false.
- precision
-
Type:
System::Byte
The total number of digits to the left and right of the decimal point to which Value is resolved.
- scale
-
Type:
System::Byte
The total number of decimal places to which Value is resolved.
- sourceColumn
-
Type:
System::String^
The name of the source column (SourceColumn) if this SqlParameter is used in a call to Update.
- sourceVersion
-
Type:
System.Data::DataRowVersion
One of the DataRowVersion values.
- value
-
Type:
System::Object^
An Object that is the value of the SqlParameter.
| Exception | Condition |
|---|---|
| ArgumentException | The value supplied in the dbType parameter is an invalid back-end data type. |
The Size and Precision are inferred from the value of the dbType parameter if they are not explicitly set in the size and precision parameters.
The following example creates a SqlParameter and sets some of its properties.
Available since 1.1