SqlParameter Constructor (String, SqlDbType, Int32, String)


The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

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 Sub New (
	parameterName As String,
	dbType As SqlDbType,
	size As Integer,
	sourceColumn As String


Type: System.String

The name of the parameter to map.

Type: System.Data.SqlDbType

One of the SqlDbType values.

Type: System.Int32

The length of the parameter.

Type: System.String

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

Exception Condition

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.

Private Sub AddSqlParameter(ByVal command As SqlCommand)

    Dim parameter As New SqlParameter("@Description", _
        SqlDbType.VarChar, 88, "Description")
    With parameter
        .IsNullable = True
        .Direction = ParameterDirection.Output
    End With

End Sub

.NET Framework
Available since 1.1
Return to top