ULTable class

Public Class ULTable Inherits ULResultSet

public class ULTable : ULResultSet

ULResultSet class

All members of ULTable class, including all inherited members.

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	Closes the cursor.
Delete method	Deletes the current row.
DeleteAllRows method	Deletes all rows in the table.
Dispose method (Inherited from System.Data.Common.DbDataReader)	Releases all resources used by the current instance of the System.Data.Common.DbDataReader class.
FindBegin method	Prepares to perform a new Find on a table.
FindFirst method	Moves forward through the table from the beginning, looking for a row that exactly matches a value or full set of values in the current index.
FindLast method	Moves backward through the table from the end, looking for a row that exactly matches a value or full set of values in the current index.
FindNext method	Continues a ULTable.FindFirst() search by moving forward through the table from the current position, looking to see if the next row exactly matches a value or full set of values in the current index.
FindPrevious method	Continues a ULTable.FindLast() search by moving backward through the table from the current position, looking to see if the previous row exactly matches a value or full set of values in the current index.
GetBoolean method	Returns the value for the specified column as a System.Boolean.
GetByte method	Returns the value for the specified column as an unsigned 8-bit value (System.Byte).
GetBytes method	UL Ext: Returns the value for the specified column as an array of System.Bytes.
GetChar method	This method is not supported in UltraLite.NET.
GetChars method	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.
GetData method (Inherited from System.Data.Common.DbDataReader)	Returns a System.Data.Common.DbDataReader object for the requested column ordinal.
GetDataTypeName method	Returns the name of the specified column's provider data type.
GetDateTime method	Returns the value for the specified column as a System.DateTime with millisecond accuracy.
GetDbDataReader method (Inherited from System.Data.Common.DbDataReader)	Returns a System.Data.Common.DbDataReader object for the requested column ordinal that can be overridden with a provider-specific implementation.
GetDecimal method	Returns the value for the specified column as a System.Decimal.
GetDouble method	Returns the value for the specified column as a System.Double.
GetEnumerator method	Returns an System.Collections.IEnumerator that iterates through the ULDataReader.
GetFieldType method	Returns the System.Type most appropriate for the specified column.
GetFloat method	Returns the value for the specified column as a System.Single.
GetGuid method	Returns the value for the specified column as a UUID (System.Guid).
GetInt16 method	Returns the value for the specified column as a System.Int16.
GetInt32 method	Returns the value for the specified column as an Int32.
GetInt64 method	Returns the value for the specified column as an Int64.
GetName method	Returns the name of the specified column.
GetOrdinal method	Returns the column ID of the named column.
GetProviderSpecificFieldType method (Inherited from System.Data.Common.DbDataReader)	Returns the provider-specific field type of the specified column.
GetProviderSpecificValue method (Inherited from System.Data.Common.DbDataReader)	Gets the value of the specified column as an instance of System.Object.
GetProviderSpecificValues method (Inherited from System.Data.Common.DbDataReader)	Gets all provider-specific attribute columns in the collection for the current row.
GetRowCount method	UL Ext: Returns the number of rows in the cursor, within threshold.
GetSchemaTable method	Returns a System.Data.DataTable that describes the column metadata of the ULDataReader.
GetString method	Returns the value for the specified column as a System.String.
GetTimeSpan method	Returns the value for the specified column as a System.TimeSpan with millisecond accuracy.
GetUInt16 method	Returns the value for the specified column as a System.UInt16.
GetUInt32 method	Returns the value for the specified column as a UInt32.
GetUInt64 method	Returns the value for the specified column as a System.UInt64.
GetValue method	Returns the value of the specified column in its native format.
GetValues method	Returns all the column values for the current row.
Insert method	Inserts a new row with the current column values (specified using the set methods).
InsertBegin method	Prepares to insert a new row into the table by setting all current column values to their default values.
IsDBNull method	Checks whether the value from the specified column is NULL.
LookupBackward method	Moves backward through the table from the end, looking for a row that matches or is less than a value or full set of values in the current index.
LookupBegin method	Prepares to perform a new lookup on the table.
LookupForward method	Moves forward through the table from the beginning, looking for a row that matches or is greater than a value or full set of values in the current index.
MoveAfterLast method	UL Ext: Positions the cursor to after the last row of the cursor.
MoveBeforeFirst method	UL Ext: Positions the cursor to before the first row of the cursor.
MoveFirst method	UL Ext: Positions the cursor to the first row of the cursor.
MoveLast method	UL Ext: Positions the cursor to the last row of the cursor.
MoveNext method	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	UL Ext: Positions the cursor to the previous row or before the first row.
MoveRelative method	UL Ext: Positions the cursor relative to the current row.
NextResult method	Advances the ULDataReader to the next result when reading the results of batch SQL statements.
Read method	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.
SetDateTime method	Sets the value for the specified column using a System.DateTime.
SetDBNull method	Sets a column to NULL.
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.
Truncate method	Deletes all rows in the table while temporarily activating a stop synchronization delete.
Update method	Updates the current row with the current column values (specified using the set methods).
UpdateBegin method	Prepares to update the current row.
Depth property	Returns the depth of nesting for the current row.
FieldCount property	Returns the number of columns in the cursor.
HasRows property	Checks whether the ULDataReader has one or more rows.
IsBOF property	UL Ext: Checks whether the current row position is before the first row.
IsClosed property	Checks whether the cursor is currently open.
IsEOF property	UL Ext: Checks whether the current row position is after the last row.
RecordsAffected property	Returns the number of rows changed, inserted, or deleted by execution of the SQL statement.
RowCount property	UL Ext: Returns the number of rows in the cursor.
Schema property	Holds the table schema.
this property	Returns the value of the specified column in its native format.
VisibleFieldCount property (Inherited from System.Data.Common.DbDataReader)	Gets the number of fields in the System.Data.Common.DbDataReader that are not hidden.

There is no constructor for this class. Tables are created using the ULCommand.ExecuteTable() of the ULCommand.

ULTable class

Visual Basic syntax

C# syntax

Base classes

Members

Remarks

See also