Windows apps
Collapse the table of content
Expand the table of content
Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

SqlParameter Constructor (String^, SqlDbType, Int32, ParameterDirection, Byte, Byte, String^, DataRowVersion, Boolean, Object^, String^, String^, String^)

 

Initializes a new instance of the SqlParameter class that uses the parameter name, the type of the parameter, the length of the parameter the direction, the precision, the scale, the name of the source column, one of the DataRowVersion values, a Boolean for source column mapping, the value of the SqlParameter, the name of the database where the schema collection for this XML instance is located, the owning relational schema where the schema collection for this XML instance is located, and the name of the schema collection for this parameter.

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

public:
SqlParameter(
	String^ parameterName,
	SqlDbType dbType,
	int size,
	ParameterDirection direction,
	unsigned char precision,
	unsigned char scale,
	String^ sourceColumn,
	DataRowVersion sourceVersion,
	bool sourceColumnNullMapping,
	Object^ value,
	String^ xmlSchemaCollectionDatabase,
	String^ xmlSchemaCollectionOwningSchema,
	String^ xmlSchemaCollectionName
)

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.

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.

sourceColumnNullMapping
Type: System::Boolean

true if the source column is nullable; false if it is not.

value
Type: System::Object^

An Object that is the value of the SqlParameter.

xmlSchemaCollectionDatabase
Type: System::String^

The name of the database where the schema collection for this XML instance is located.

xmlSchemaCollectionOwningSchema
Type: System::String^

The owning relational schema where the schema collection for this XML instance is located.

xmlSchemaCollectionName
Type: System::String^

The name of the schema collection for this parameter.

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.

.NET Framework
Available since 2.0
Return to top
Show:
© 2017 Microsoft