SqlParameter.ParameterName Property

Definition

Namespace:

Microsoft.Data.SqlClient

Assembly:

Microsoft.Data.SqlClient.dll

Package:

Microsoft.Data.SqlClient v5.2.0

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

String

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

Implements

ParameterName

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.