The CSearch type exposes the following members.

Methods

  NameDescription
Public methodClear
Clear previous search criteria and results
Public methodColumn(String)
Define a column of data to retrieve
Public methodColumn(String, String)
Define a table and column of data to retrieve
Public methodColumn(String, String, String)
Define a table and column of data to retrieve and assign an alias for the results
Public methodCondition(Collection<(Of <<'(CCondition>)>>))
Collection of Conditions. Require for advanced JOIN statements
(Inherited from CConditionCommon.)
Public methodCondition(CCondition)
Add a CCondition to the comparison stack
(Inherited from CConditionCommon.)
Public methodCondition(eLogic)
Required to concatenate multiple conditions together
(Inherited from CConditionCommon.)
Public methodCondition(String, eOperator)
Check if a column IsNull or IsNotNull
(Inherited from CConditionCommon.)
Public methodCondition(String, String, eOperator)
Check if a column in a table IsNull or IsNotNull
(Inherited from CConditionCommon.)
Public methodCondition(String, eOperator, Object)
Compare a column to data
(Inherited from CConditionCommon.)
Public methodCondition(String, String, eOperator, Object)
Compare a table column to data
(Inherited from CConditionCommon.)
Public methodCondition(String, eOperator, Object, Object)
Used to perform a Bitwise compare on a column
(Inherited from CConditionCommon.)
Public methodCondition(String, String, eOperator, Object, Object)
Used to perform a Bitwise compare on a table and a column
(Inherited from CConditionCommon.)
Public methodCondition(String, String, eOperator, String, String)
Compare a column in one table to a column in another table
(Inherited from CConditionCommon.)
Public methodCount(String)
Returns number of rows in table
Public methodCount(String, String)
Returns number of rows in table that are not null
Public methodDistinct
Return only distinct/difference rows
Public methodDistinctCount
Returns number of distinct/different rows in table
Public methodExecute
Perform search on database
Public methodGet(String, Boolean%)
Retrieve data from a column as a string
Public methodGet(String, Byte%)
Retrieve data from a column as a byte
Public methodGet(String, array<Byte>[]()[][]%)
Retrieve data from a column as a byte array
Public methodGet(String, Char%)
Retrieve data from a column as a char
Public methodGet(String, array<Char>[]()[][]%)
Retrieve data from a column as a char array
Public methodGet(String, DateTime%)
Retrieve data from a column as a DateTime
Public methodGet(String, Decimal%)
Retrieve data from a column as a decimal
Public methodGet(String, Double%)
Retrieve data from a column as a double
Public methodGet(String, Image%)
Retrieve data from a column as an Image
Public methodGet(String, Int16%)
Retrieve data from a column as a short (Int16)
Public methodGet(String, Int32%)
Retrieve data from a column as a int (Int32)
Public methodGet(String, Int64%)
Retrieve data from a column as a long (Int64)
Public methodGet(String, MemoryStream%)
Retrieve data from a column as a MemoryStream
Public methodGet(String, Stream%)
Retrieve data from a column as a Stream
Public methodGet(String, Single%)
Retrieve data from a column as a float
Public methodGet(String, String%)
Retrieve data from a column as a string
Public methodGetObject
Retrieve data from a column as an object
Public methodJoin(String, String, Collection<(Of <<'(CCondition>)>>), eJoinType)
JOIN two tables together with an alias based on a collection of conditions
Public methodJoin(String, String, CCondition, eJoinType)
JOIN two tables together with an alias based on a CCondition
Public methodJoin(String, String, eOperator, Object, eJoinType)
JOIN two tables together based on a relationship of a column and data
Public methodJoin(String, String, eOperator, String, String, eJoinType)
JOIN two tables together based on a relationship of columns
Public methodLimit
Limit number of results returned
Public methodOffset
Position to start search
Public methodRead
Read one record from search results
Public methodSort(String)
Sort search results by column using default sort order
Public methodSort(String, String)
Sort search results by column in table using default sort order
Public methodSort(String, eSort)
Sort search results by column selected sort order
Public methodSort(String, String, eSort)
Sort search results by column in table using selected sort order
Public methodTable
Set main table name to search

See Also