Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
SqlParameter Constructor (String, SqlDbType, Int32, String)

SqlParameter Constructor (String, SqlDbType, Int32, String)

Initializes a new instance of the SqlParameter class that uses the parameter name, the SqlDbType, the size, and the source column name.

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

public:
SqlParameter(
	String^ parameterName, 
	SqlDbType dbType, 
	int size, 
	String^ sourceColumn
)

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.

sourceColumn
Type: System::String

The name of the source column (SourceColumn) if this SqlParameter is used in a call to Update.

ExceptionCondition
ArgumentException

The value supplied in the dbType parameter is an invalid back-end data type.

The Size is inferred from the value of the dbType parameter if it is not explicitly set in the size parameter.

The following example creates a SqlParameter and sets some of its properties.

No code example is currently available or this language may not be supported.

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1

.NET Framework Client Profile

Supported in: 4, 3.5 SP1
Show:
© 2015 Microsoft