CodeCharge Studio | All ASP PHP Perl ColdFusion Java C#.NET VB.NET |
Property | Description |
---|---|
Name | Name of the control. |
Connection | Select one of the project database connection names. |
Data Source Type | Specify the type of Data Source. |
Data Source | Specify the actual source of data for the list of values depending on the Source Type. |
ID Field | Specify the field containing the unique ID that identifies the categories. |
Parent Field | Specify the field with primary key values of the parent categories. |
Event | Description |
---|---|
Server Side Events | |
Before Select | This event occurs at the onset of the operations performed to select records from the database. |
Before Show | This event occurs before a component is rendered to the page. |
Before Show Category | This event occurs before each category in the Path is displayed. |
Before Build Select | This event occurs before the creation of the query that will be used to retrieve records from the database. |
Before Execute Select | This event occurs immediately before a row selection query is executed but after the query has been composed. |
After Execute Select | This event occurs after the row selection query has been executed and a recordset for the result is returned. |
Property | Description |
---|---|
DataSource | This property stores a reference to the data source bound to the component. The data source handles all data retrieval and update operations. It serves as an abstraction layer that hides underlying data source details, whether it is a database table, SQL query or stored procedure. |
Errors | This property contains any error messages pertaining to the entire form as a whole. |
Recordset | This property contains a recordset in which are all the records that will be shown in the form. |
Visible | This property determines whether the component is to be shown or not. |
Property | Description |
---|---|
DataSource.SQL | This property contains the main portion of the SQL query used to retrieve the records displayed within the component. In terms of SQL, this property defines the SELECT and FROM clauses of the SQL query. |
DataSource.Where | This property contains the WHERE clause portion of the SQL query used to retrieve records for the component. The WHERE clause provides the criteria which filters the records retrieved. The value of this property is appended to the value of the DataSource.SQL property to create the final SQL query which is executed against the datasource to retrieve the records for the component. |
Property | Description |
---|---|
ComponentType | Specifies type of an object, such as "TextBox", "Record", etc. |
Parent | Specifies parent container of an object, for example a record form for a textbox that is included within that form. |
DataSource | This property stores a reference to the data source bound to the specified object. The data source handles all data retrieval and update operations. It serves as an abstraction layer that hides underlying data source details, whether it is a database table, SQL query or stored procedure. |
Errors | This property keeps the reference to the object’s error collection. It is used to collect error messages generated during the object’s execution. |
Visible | This property determines whether the component is to be shown or not. |
Property | Description |
---|---|
DataSource->SQL | This property contains the main portion of the SQL query used to retrieve the records displayed within the component. In terms of SQL, this property defines the SELECT and FROM clauses of the SQL query. |
DataSource->Where | This property contains the WHERE clause portion of the SQL query used to retrieve records for the component. The WHERE clause provides the criteria which filters the records retrieved. The value of this property is appended to the value of the DataSource->SQL property to create the final SQL query which is executed against the datasource to retrieve the records for the component. |
Property | Description |
---|---|
DataSource | This property stores a reference to the data source bound to the component. | Visible | This property determines whether the component will be shown or not. |
Property | Description |
---|---|
errors | This property keeps a reference to the object’s error collection. It is used to collect error messages generated during the object’s execution. |
<control name> | For each control that is located within a component, a member property is created with the same name as the control. |
Property | Description |
---|---|
<prefix><parameter name> | For each unique parameter of the Data Source command, a member property is created with the prefix (according to parameter source type) and parameter name (according to parameter source). |
Method | Description |
---|---|
GetResultSet | Executes an SQL command and returns results in an Items array. |
Property | Description |
---|---|
query<control name> | This variable contains the query object associated with the component. |
strOrder | This variable contains the ORDER BY clause portion of the SQL query used to retrieve records for the control. The ORDER BY clause determines the order of appearance of the retrieved records. The value of this property is appended to the value of the strSQL variable to create the final SQL query which is executed against the datasource to retrieve the records for the control. |
strSQL | This variable contains the main portion of the SQL query used to retrieve the records displayed within the component. In terms of SQL, this property defines the SELECT and FROM clauses of the SQL query. |
strWhere | This variable contains the WHERE clause portion of the SQL query used to retrieve records for the component. The WHERE clause provides the criteria which filters the records retrieved. The value of this property is appended to the value of the strSQL variable to create the final SQL query which is executed against the datasource to retrieve the records for the component. |
hide<control name> | This variable determines whether the control is to be shown or not. |
Method | Description |
---|---|
isRestricted | Indicates whether users must be logged in before accessing the component. |
setRestricted | Specify whether users must be logged in before accessing the component. |
getPageModel | Get the page to which the component belongs. |
isProcessed | Indicate whether the component has been processed. |
hasNextRow | Returns true if there are more elements in a collection |
nextRow | Returns the next row. If the next row isn't available, this method returns an empty HashMap; This method never returns a null. |
currentRow | Returns the current row. |
getChild | Specify a name to find a child control among the collection of children controls. |
getChildren | Return all children controls of a collection. |
getControl | Specify a name to find a Control among the collection of controls. |
getFileUpload | Specify a name to find a FileUpload control among the collection of children controls. |
getButton | Specify a name to find a Button control among the collection of children controls. |
getListBox | Specify a name to find a Listbox control among the collection of children controls. |
getRadioButton | Specify a name to find a Radiobutton control among the collection of children controls. |
getCheckBoxList | Specify a name to find a Checkbox List control among the collection of children controls. |
getLink | Specify a name to find a Link control among the collection of children controls. |
getDatePicker | Specify a name to find a Date Picker control among the collection of children controls. |
isVisible | Returns a value indicating whether this control should be displayed or not. |
setVisible | Specify whether this component should be shown. |
getParent | Get the parent component that contains this control or component. |