The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.
SqlParameter::Direction Property
.NET Framework (current version)
Gets or sets a value that indicates whether the parameter is input-only, output-only, bidirectional, or a stored procedure return value parameter.
Assembly: System.Data (in System.Data.dll)
public: property ParameterDirection Direction { virtual ParameterDirection get() override; virtual void set(ParameterDirection value) override; }
Property Value
Type: System.Data::ParameterDirectionOne of the ParameterDirection values. The default is Input.
| Exception | Condition |
|---|---|
| ArgumentException | The property was not set to one of the valid ParameterDirection values. |
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.
The following example creates a SqlParameter and sets some of its properties.
.NET Framework
Available since 1.1
Available since 1.1
Show: