IDataParameter.ParameterName Property


Gets or sets the name of the IDataParameter.

 property System::String ^ ParameterName { System::String ^ get(); void set(System::String ^ value); };
public string ParameterName { get; set; }
member this.ParameterName : string with get, set
Public Property ParameterName As String

Property Value

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


The following example creates an instance of the implementing class, SqlParameter, and sets some of its properties.

private static void AddSqlParameter(SqlCommand command)
    SqlParameter parameter = new SqlParameter();
    parameter.ParameterName = "@Description";
    parameter.IsNullable = true;
    parameter.DbType = DbType.String;
    parameter.Direction = ParameterDirection.Output;

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

End Sub


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

Applies to