Share via


SqlParameter.ParameterName Property

Definition

Gets or sets the name of the SqlParameter.

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

Property Value

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

Implements

Examples

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

using Microsoft.Data.SqlClient;

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

        command.Parameters.Add(parameter);
    }
}

Remarks

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

Applies to