PickDPDataReader Class

Provides a means of reading a forward-only stream of rows from a Pick Server database. This class cannot be inherited.

Public Methods

Close (Inherits from IDataReader)	Closes the System.Data.PickDP.PickDPDataReader object.
GetAllowDBNull	Gets whether the specified column allows null values as specified in the Administration program.
GetBoolean (Inherits from IDataRecord)	Gets the value of the specified column as a Boolean.
GetByte (Inherits from IDataRecord)	Gets the byte representation of the first character in the value of the column.
GetBytes (Inherits from IDataRecord)	Gets the value in a byte[] buffer.
GetCaption	Gets the caption of the specified field from the schema.
GetChar (Inherits from IDataRecord)	Gets the char representation of the first character in the value of the column.
GetChars (Inherits from IDataRecord)	Gets the value in a char[] buffer.
GetData (Inherits from IDataRecord)	Gets a System.Data.IDataReader to be used when the field points to more remote structured data.
GetDataTypeName (Inherits from IDataRecord)	Gets the data type information for the specified field.
GetDateTime	Gets the date and time data value of the specified field.
GetDecimal	Gets the fixed-position numeric value of the specified field.
GetDouble	Gets the double-precision floating point number of the specified field.
GetFieldType (Inherits from IDataRecord)	Gets the System.Type information corresponding to the type of System.Object that would be returned from System.Data.IDataRecord.GetValue(System.Int32) .
GetFloat	Gets the single-precision floating point number of the specified field.
GetGuid (Inherits from IDataRecord)	Returns the guid value of the specified field. NOTE- This method is not supported and returns a NotSupported exception.
GetInt16	Gets the 16-bit signed integer value of the specified field.
GetInt32	Gets the 32-bit signed integer value of the specified field.
GetInt64	Gets the 64-bit signed integer value of the specified field.
GetMaxLength	Gets the maximum length of the specified field.
GetName (Inherits from IDataRecord)	Gets the name of the field to find.
GetOrdinal (Inherits from IDataRecord)	Returns the column name of the named field.
GetReadOnly	Gets a read-only copy of the specified field. Not implemented at this time.
GetSchemaTable (Inherits from IDataReader)	Returns a System.Data.DataTable that describes the column metadata of the System.Data.IDataReader.
GetString	Gets the string value of the specified field.
GetTime	Gets the time of the specified field.
GetValue	Returns the value of the specified field.
GetValues (Inherits from IDataRecord)	Gets all the attribute fields in the collection for the current record.
IsDBNull (Inherits from IDataRecord)	Returns whether the specified field is set to null.
NextResult (Inherits from IDataReader)	Advances the data reader to the next result when reading the results of batch Pick statements.
Read (Inherits from IDataReader)	Advances the System.Data.IDataReader to the next record.

Public Properties

Name	Type	Description
Depth	Integer	Gets a value indicating the depth of nesting for the current row.
FieldCount	Integer	Gets the number of columns in the current row.
HasRows	Boolean	Gets a value indicating whether the System.Data.PickDP.PickDPDataReader contains one or more rows.
IsClosed	Boolean	Gets a value indicating whether the data reader is closed.
Item	Object	Gets the column with the specified name.
Item	Object	Gets the column located at the specified index.
RecordsAffected	Integer	Gets the number of rows changed, inserted, or deleted by execution of the Pick statement.