Name
Parameter.Direction Property — (Versions 2.0, 2.1, 2.5, 2.6)
Synopsis
parameter.Direction = ParameterDirectionEnum
The Direction property specifies whether the current parameter is an input parameter, an output parameter, both an input and an output parameter, or a return value from a stored procedure.
Datatype
ParameterDirectionEnum (Long)
Description
The Direction property is both read- and write-enabled. It is to your advantage to add parameters manually to a Parameters collection so that ADO does not have to make additional calls to the data provider to locate this information itself. In some cases, you must specify the Direction property manually because the particular data provider may not be able to determine this information itself.
The Direction property may be set to one of the ParameterDirectionEnum enumerations listed in Appendix E.
Note
Not all providers can determine the value of the Direction property; therefore, for such providers the application must manually set the value of the Direction property for parameters before they are used.
See Also
ParameterDirectionEnum Enumeration
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access