SqlParameter.ParameterName Property

 

Gets or sets the name of the SqlParameter.

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

Public Overrides Property ParameterName As String

Property Value

Type: System.String

The name of the SqlParameter. The default is an empty string.

The ParameterName is specified in the form @paramname. You must set ParameterName before executing a SqlCommand that relies on parameters.

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

Private Sub AddSqlParameter(ByVal command As SqlCommand)

    Dim parameter As New SqlParameter()
    With parameter
        .ParameterName = "@Description"
        .IsNullable = True
        .DbType = DbType.String
        .Direction = ParameterDirection.Output
    End With

    command.Parameters.Add(parameter)
End Sub

.NET Framework
Available since 1.1
Return to top
Show: