PreviousData Provider for .NET Guide (9.1 revision 1) Next

PsqlParameter Object

Show this topic in Library frames

The PsqlParameter object represents a parameter to an PsqlCommand object. The code examples include a code example that uses parameters.

Table 4-18 describes the public properties for PsqlParameter.

Table 4-18 Public Properties of the PsqlParameter Object  
Property
Description
DbType
Gets or sets the DbType of the parameter.
Direction
Gets or sets a value that indicates whether the parameter is input-only, output-only, bidirectional, or the return value parameter of a stored procedure.
IsNullable
Gets or sets a value that indicates whether the parameter accepts null values.
ParameterName
Gets or sets the name of the data provider's Parameter object.
Precision
Gets or sets the maximum number of digits used to represent the Value property.
Scale
Gets or sets the number of decimal places to which Value is resolved.
Size
Gets or sets the maximum size, in bytes, of the data within the column.
SourceColumn
Gets or sets the name of the source column that is mapped to the DataSet and used for loading or returning the Value.
SourceVersion
Gets or sets the DataRowVersion to use when loading Value.
Value
Gets or sets the value of the parameter.
The initial default value is null.
Note: When array binding is enabled (see ArrayBindCount property of the PsqlCommand Object), this property is specified as an array of values. Each array's length must match the value of the ArrayBindCount property. When specifying the array's values for binary type columns, the data will actually be specified as byte[]. This is an array of arrays of bytes. The data provider anticipates a "jagged" array as such when using parameter array binding with parameters.


Chapter contents
Publication contents

Prev topic: PsqlInfoMessageEventArgs Object
Next topic: PsqlParameterCollection Object