Windows apps
Collapse the table of content
Expand the table of content
Information
Switch
Switch
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)

.NET Framework (current version)
 

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

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

C#
C++
F#
VB
Copy 
public:
SqlParameter(
	String^ parameterName,
	SqlDbType dbType,
	int size
)

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.

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

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

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