Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » UltraLite - .NET Programming » UltraLite .NET 2.0 API Reference » ULTable class

 

ULTable 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

Holds the table schema. This property is only valid while its connection is open.

[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 (inherited from ULResultSet)

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

AppendChars method (inherited from ULResultSet)

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 (inherited from ULResultSet)

Deletes the current row.

DeleteAllRows method

Deletes all rows in the table.

[external link] Dispose (inherited from DbDataReader)

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

FindBegin method

Prepares to perform a new Find on a table.

FindFirst methods

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 methods

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 methods

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 methods

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 (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.

Insert method

Inserts a new row with the current column values (specified using the set methods).

Each insert must be preceded by a call to ULTable.InsertBegin.

InsertBegin method

Prepares to insert a new row into the table by setting all current column values to their default values.

IsDBNull method (inherited from ULDataReader)

Checks whether the value from the specified column is NULL.

LookupBackward methods

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. The value(s) for which to search are specified by calling the appropriate setType method(s) on the columns in the index with which the table was opened.

LookupForward methods

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 (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 (inherited from ULResultSet)

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

SetByte method (inherited from ULResultSet)

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

SetBytes method (inherited from ULResultSet)

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

SetDBNull method (inherited from ULResultSet)

Sets a column to NULL.

SetDateTime method (inherited from ULResultSet)

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

SetDecimal method (inherited from ULResultSet)

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

SetDouble method (inherited from ULResultSet)

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

SetFloat method (inherited from ULResultSet)

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

SetGuid method (inherited from ULResultSet)

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

SetInt16 method (inherited from ULResultSet)

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

SetInt32 method (inherited from ULResultSet)

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

SetInt64 method (inherited from ULResultSet)

Sets the value for the specified column using an Int64.

SetString method (inherited from ULResultSet)

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

SetTimeSpan method (inherited from ULResultSet)

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

SetToDefault method (inherited from ULResultSet)

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

SetUInt16 method (inherited from ULResultSet)

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

SetUInt32 method (inherited from ULResultSet)

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

SetUInt64 method (inherited from ULResultSet)

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 (inherited from ULResultSet)

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

UpdateBegin method

Prepares to update the current row in the table.

See also