SqlParameter.Direction Property
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Gets or sets a value that indicates whether the parameter is input-only, output-only, bidirectional, or a stored procedure return value parameter.
public:
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, setPublic Overrides Property Direction As ParameterDirectionOne of the ParameterDirection values. The default is Input.
The property was not set to one of the valid ParameterDirection values.
The following example creates a SqlParameter and sets some of its properties.
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.
| Product | Versions |
|---|---|
| SqlClient .NET Core | 1.0, 1.1, 2.0, 2.1, 3.0, 3.1, 4.0, 4.1, 5.0, 5.1, 5.2 |
| SqlClient .NET Framework | 1.0, 1.1, 2.0, 2.1, 3.0, 3.1, 4.0, 4.1, 5.0, 5.1, 5.2 |
| SqlClient .NET Standard | 1.0, 1.1, 2.0, 2.1, 3.0, 3.1, 4.0, 4.1, 5.0, 5.1, 5.2 |