SqlParameter.Direction SqlParameter.Direction SqlParameter.Direction SqlParameter.Direction Property


Gets or sets a value that indicates whether the parameter is input-only, output-only, bidirectional, or a stored procedure return value parameter.

 virtual property System::Data::ParameterDirection Direction { System::Data::ParameterDirection get(); void set(System::Data::ParameterDirection value); };
public override System.Data.ParameterDirection Direction { get; set; }
member this.Direction : System.Data.ParameterDirection with get, set
Public Overrides Property Direction As ParameterDirection

Property Value



The property was not set to one of the valid ParameterDirection values.


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

Commands and Parameters

DataAdapter Parameters

SQL Server and ADO.NET


If the ParameterDirection is output, and execution of the associated SqlCommand does not return a value, the SqlParameter contains a null value.

Output, InputOut, and ReturnValue parameters returned by calling ExecuteReader cannot be accessed until you close the SqlDataReader.

Applies to

See also