The CSearch type exposes the following members.
Methods
Name | Description | |
---|---|---|
![]() | Clear |
Clear previous search criteria and results
|
![]() | Column(String) |
Define a column of data to retrieve
|
![]() | Column(String, String) |
Define a table and column of data to retrieve
|
![]() | Column(String, String, String) |
Define a table and column of data to retrieve and assign an alias for the results
|
![]() | Condition(Collection<(Of <<'(CCondition>)>>)) |
Collection of Conditions. Require for advanced JOIN statements
(Inherited from CConditionCommon.) |
![]() | Condition(CCondition) |
Add a CCondition to the comparison stack
(Inherited from CConditionCommon.) |
![]() | Condition(eLogic) |
Required to concatenate multiple conditions together
(Inherited from CConditionCommon.) |
![]() | Condition(String, eOperator) |
Check if a column IsNull or IsNotNull
(Inherited from CConditionCommon.) |
![]() | Condition(String, String, eOperator) |
Check if a column in a table IsNull or IsNotNull
(Inherited from CConditionCommon.) |
![]() | Condition(String, eOperator, Object) |
Compare a column to data
(Inherited from CConditionCommon.) |
![]() | Condition(String, String, eOperator, Object) |
Compare a table column to data
(Inherited from CConditionCommon.) |
![]() | Condition(String, eOperator, Object, Object) |
Used to perform a Bitwise compare on a column
(Inherited from CConditionCommon.) |
![]() | Condition(String, String, eOperator, Object, Object) |
Used to perform a Bitwise compare on a table and a column
(Inherited from CConditionCommon.) |
![]() | Condition(String, String, eOperator, String, String) |
Compare a column in one table to a column in another table
(Inherited from CConditionCommon.) |
![]() | Count(String) |
Returns number of rows in table
|
![]() | Count(String, String) |
Returns number of rows in table that are not null
|
![]() | Distinct |
Return only distinct/difference rows
|
![]() | DistinctCount |
Returns number of distinct/different rows in table
|
![]() | Execute |
Perform search on database
|
![]() | Get(String, Boolean%) |
Retrieve data from a column as a string
|
![]() | Get(String, Byte%) |
Retrieve data from a column as a byte
|
![]() | Get(String, array<Byte>[]()[][]%) |
Retrieve data from a column as a byte array
|
![]() | Get(String, Char%) |
Retrieve data from a column as a char
|
![]() | Get(String, array<Char>[]()[][]%) |
Retrieve data from a column as a char array
|
![]() | Get(String, DateTime%) |
Retrieve data from a column as a DateTime
|
![]() | Get(String, Decimal%) |
Retrieve data from a column as a decimal
|
![]() | Get(String, Double%) |
Retrieve data from a column as a double
|
![]() | Get(String, Image%) |
Retrieve data from a column as an Image
|
![]() | Get(String, Int16%) |
Retrieve data from a column as a short (Int16)
|
![]() | Get(String, Int32%) |
Retrieve data from a column as a int (Int32)
|
![]() | Get(String, Int64%) |
Retrieve data from a column as a long (Int64)
|
![]() | Get(String, MemoryStream%) |
Retrieve data from a column as a MemoryStream
|
![]() | Get(String, Stream%) |
Retrieve data from a column as a Stream
|
![]() | Get(String, Single%) |
Retrieve data from a column as a float
|
![]() | Get(String, String%) |
Retrieve data from a column as a string
|
![]() | GetObject |
Retrieve data from a column as an object
|
![]() | Join(String, String, Collection<(Of <<'(CCondition>)>>), eJoinType) |
JOIN two tables together with an alias based on a collection of conditions
|
![]() | Join(String, String, CCondition, eJoinType) |
JOIN two tables together with an alias based on a CCondition
|
![]() | Join(String, String, eOperator, Object, eJoinType) |
JOIN two tables together based on a relationship of a column and data
|
![]() | Join(String, String, eOperator, String, String, eJoinType) |
JOIN two tables together based on a relationship of columns
|
![]() | Limit |
Limit number of results returned
|
![]() | Offset |
Position to start search
|
![]() | Read |
Read one record from search results
|
![]() | Sort(String) |
Sort search results by column using default sort order
|
![]() | Sort(String, String) |
Sort search results by column in table using default sort order
|
![]() | Sort(String, eSort) |
Sort search results by column selected sort order
|
![]() | Sort(String, String, eSort) |
Sort search results by column in table using selected sort order
|
![]() | Table |
Set main table name to search
|