SqlParameter Constructor (String, SqlDbType)

 

Initializes a new instance of the SqlParameter class that uses the parameter name and the data type.

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

Public Sub New (
	parameterName As String,
	dbType As SqlDbType
)

Parameters

parameterName
Type: System.String

The name of the parameter to map.

dbType
Type: System.Data.SqlDbType

One of the SqlDbType values.

Exception Condition
ArgumentException

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

The data type and, if appropriate, Size and Precision are inferred from the value of the dbType parameter.

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

Private Sub AddSqlParameter(ByVal command As SqlCommand, _
    ByVal paramValue As String)

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

    command.Parameters.Add(parameter)
End Sub

.NET Framework
Available since 1.1
Return to top
Show: