ULResultSet members

Public properties
Member name Description

Depth property (inherited from ULDataReader)

Returns the depth of nesting for the current row. The outermost table has a depth of zero.

FieldCount property (inherited from ULDataReader)

Returns the number of columns in the cursor.

HasRows property (inherited from ULDataReader)

Checks whether the ULDataReader has one or more rows.

IsBOF property (inherited from ULDataReader)

UL Ext.: Checks whether the current row position is before the first row.

IsClosed property (inherited from ULDataReader)

Checks whether the cursor is currently open.

IsEOF property (inherited from ULDataReader)

UL Ext.: Checks whether the current row position is after the last row.

Item properties (inherited from ULDataReader)

Gets the value of a specified column as an instance of [external link] Object.

RecordsAffected property (inherited from ULDataReader)

Returns the number of rows changed, inserted, or deleted by execution of the SQL statement. For SELECT statements or CommandType.TableDirect tables, this value is -1.

RowCount property (inherited from ULDataReader)

UL Ext.: Returns the number of rows in the cursor.

Schema property (inherited from ULDataReader)

UL Ext.: Holds the schema of this cursor.

[external link] VisibleFieldCount (inherited from DbDataReader)

Gets the number of fields in the [external link] DbDataReader that are not hidden.

Public methods
Member name Description

AppendBytes method

Appends the specified subset of the specified array of System.Bytes to the new value for the specified ULDbType.LongBinary column.

AppendChars method

Appends the specified subset of the specified array of System.Chars to the new value for the specified ULDbType.LongVarchar column.

Close method (inherited from ULDataReader)

Closes the cursor.

Delete method

Deletes the current row.

[external link] Dispose (inherited from DbDataReader)

Releases the resources consumed by this [external link] DbDataReader.

GetBoolean method (inherited from ULDataReader)

Returns the value for the specified column as a System.Boolean.

GetByte method (inherited from ULDataReader)

Returns the value for the specified column as an unsigned 8-bit value (System.Byte).

GetBytes methods (inherited from ULDataReader)

UL Ext.: Returns the value for the specified column as an array of System.Bytes. Only valid for columns of type ULDbType.Binary, ULDbType.LongBinary, or ULDbType.UniqueIdentifier.

GetChar method (inherited from ULDataReader)

This method is not supported in UltraLite.NET.

GetChars method (inherited from ULDataReader)

Copies a subset of the value for the specified ULDbType.LongVarchar column, beginning at the specified offset, to the specified offset of the destination System.Char array.

[external link] GetData (inherited from DbDataReader)

Returns a [external link] DbDataReader object for the requested column ordinal.

GetDataTypeName method (inherited from ULDataReader)

Returns the name of the specified column's provider data type.

GetDateTime method (inherited from ULDataReader)

Returns the value for the specified column as a System.DateTime with millisecond accuracy.

GetDecimal method (inherited from ULDataReader)

Returns the value for the specified column as a System.Decimal.

GetDouble method (inherited from ULDataReader)

Returns the value for the specified column as a System.Double.

GetEnumerator method (inherited from ULDataReader)

Returns an System.Collections.IEnumerator that iterates through the ULDataReader.

GetFieldType method (inherited from ULDataReader)

Returns the System.Type most appropriate for the specified column.

GetFloat method (inherited from ULDataReader)

Returns the value for the specified column as a System.Single.

GetGuid method (inherited from ULDataReader)

Returns the value for the specified column as a UUID (System.Guid).

GetInt16 method (inherited from ULDataReader)

Returns the value for the specified column as a System.Int16.

GetInt32 method (inherited from ULDataReader)

Returns the value for the specified column as an Int32.

GetInt64 method (inherited from ULDataReader)

Returns the value for the specified column as an Int64.

GetName method (inherited from ULDataReader)

Returns the name of the specified column.

GetOrdinal method (inherited from ULDataReader)

Returns the column ID of the named column.

[external link] GetProviderSpecificFieldType (inherited from DbDataReader)

Returns the provider-specific field type of the specified column.

[external link] GetProviderSpecificValue (inherited from DbDataReader)

Gets the value of the specified column as an instance of [external link] Object.

[external link] GetProviderSpecificValues (inherited from DbDataReader)

Gets all provider-specific attribute columns in the collection for the current row.

GetSchemaTable method (inherited from ULDataReader)

Returns a System.Data.DataTable that describes the column metadata of the ULDataReader.

GetString method (inherited from ULDataReader)

Returns the value for the specified column as a System.String.

GetTimeSpan method (inherited from ULDataReader)

Returns the value for the specified column as a System.TimeSpan with millisecond accuracy.

GetUInt16 method (inherited from ULDataReader)

Returns the value for the specified column as a System.UInt16.

GetUInt32 method (inherited from ULDataReader)

Returns the value for the specified column as a UInt32.

GetUInt64 method (inherited from ULDataReader)

Returns the value for the specified column as a System.UInt64.

GetValue method (inherited from ULDataReader)

Returns the value of the specified column in its native format.

GetValues method (inherited from ULDataReader)

Returns all the column values for the current row.

IsDBNull method (inherited from ULDataReader)

Checks whether the value from the specified column is NULL.

MoveAfterLast method (inherited from ULDataReader)

UL Ext.: Positions the cursor to after the last row of the cursor.

MoveBeforeFirst method (inherited from ULDataReader)

UL Ext.: Positions the cursor to before the first row of the cursor.

MoveFirst method (inherited from ULDataReader)

UL Ext.: Positions the cursor to the first row of the cursor.

MoveLast method (inherited from ULDataReader)

UL Ext.: Positions the cursor to the last row of the cursor.

MoveNext method (inherited from ULDataReader)

UL Ext.: Positions the cursor to the next row or after the last row if the cursor was already on the last row.

MovePrevious method (inherited from ULDataReader)

UL Ext.: Positions the cursor to the previous row or before the first row.

MoveRelative method (inherited from ULDataReader)

UL Ext.: Positions the cursor relative to the current row.

NextResult method (inherited from ULDataReader)

Advances the ULDataReader to the next result when reading the results of batch SQL statements.

Read method (inherited from ULDataReader)

Positions the cursor to the next row, or after the last row if the cursor was already on the last row.

SetBoolean method

Sets the value for the specified column using a System.Boolean.

SetByte method

Sets the value for the specified column using a System.Byte (unsigned 8-bit integer).

SetBytes method

Sets the value for the specified column using an array of System.Bytes.

SetDBNull method

Sets a column to NULL.

SetDateTime method

Sets the value for the specified column using a ="System.DateTime.

SetDecimal method

Sets the value for the specified column using a System.Decimal.

SetDouble method

Sets the value for the specified column using a System.Double.

SetFloat method

Sets the value for the specified column using a System.Single.

SetGuid method

Sets the value for the specified column using a System.Guid.

SetInt16 method

Sets the value for the specified column using an System.Int16.

SetInt32 method

Sets the value for the specified column using an System.Int32.

SetInt64 method

Sets the value for the specified column using an Int64.

SetString method

Sets the value for the specified column using a System.String.

SetTimeSpan method

Sets the value for the specified column using a System.TimeSpan.

SetToDefault method

Sets the value for the specified column to its default value.

SetUInt16 method

Sets the value for the specified column using a System.UInt16.

SetUInt32 method

Sets the value for the specified column using an System.UInt32.

SetUInt64 method

Sets the value for the specified column using a System.UInt64.

Update method

Updates the current row with the current column values (specified using the set methods).

See also