Parameter Object
A Parameter object represents a parameter or argument associated with a
Command object based on a parameterized query or stored procedure.
Properties
Attributes, Direction,
Name, NumericScale,
Precision, Size, Type,
Value
Methods
AppendChunk
Remarks
Parameter objects represent parameters associated with parameterized
queries, or the in/out arguments or return values of stored procedures.
Depending on the functionality the provider exposes, some collections,
methods, or properties of a Parameter object may not be available.
With the collections, methods, and properties of a Parameter object,
you can do the following:
· Set or return the name of a parameter
with the Name property.
· Set or return the value of a parameter
with the Value property.
· Set or return parameter characteristics
with the Attributes and Direction,
Precision, NumericScale,
Size, and Type
properties.
· Pass long binary or character data to a
parameter with the AppendChunk method.
If you know the names and properties of the parameters associated with the
stored procedure or parameterized query you wish to call, you can use the CreateParameter
method to create Parameter objects with the appropriate property
settings and use the Append method to add them to
the Parameters collection. This lets you set
and return parameter values without having to call the Refresh
method on the Parameters collection to retrieve the parameter
information from the provider, a potentially resource-intensive operation.
To refer to a Parameter object in a collection by its ordinal number or
by its Name property setting, use any of the following syntax forms:
command.Parameters.Item(0)
command.Parameters.Item("name")
command.Parameters(0)
command.Parameters("name")
command(0)
command("name")
command![name]
See Also
Command, CreateParameter,
Item, Parameters
| 
