CodeCharge Studio | All ASP PHP Perl ColdFusion Java C#.NET VB.NET |
Property | Description |
---|---|
Name | The name of the control. |
Visible | Specify whether the control should be displayed or not. |
Caption | The name used to refer to the control in an error message. |
Control Source Type | The type of data source that will provide data for the control: Database Column, Code Expression. |
Control Source | Specify the source of data for the control. |
Connection | The database connection from where information will be retrieved. |
Data Source Type | Specify the type of source of data for the list of values to be shown in the control. |
Data Source | Specify the actual source of data for the list of values depending on the List Source Type. |
Bound Column | Refers to the data source for the values that are submitted. |
Text Column | Refers to the data source for the values that are displayed. |
Data Type | The type of data that will be contained in the control. |
Default Value | Specify a default value to be used for the control if no value is otherwise specified. |
Required | Yes/No] Select ‘Yes’ if a value must be entered for the control in order for the form to be submitted successfully. |
Unique | [Yes/No] Select ‘Yes’ if you want a check to be made to ensure that any value entered in the control does not already exist in the database. |
Error Control | Specify the name of a control that will be used to display any error messages pertaining to the control. If this value is not specified, all error messages are displayed at the top of the form in which the control is contained. |
Validation Rule | Specify an expression that will be used to check the validity of the data entered in the control. |
Validation Text | Specify the text that will be displayed if the data entered in the control does not meet the validation rule. |
Event | Description |
---|---|
Server Side Events | |
On Validate | This event occurs after standard validation operations have been performed as a result of submitting values, but before any database operations have been performed with the submitted values. |
Before Show | This event occurs before the control is rendered to the page. |
Before Build Select | This event occurs before the query that will be used to retrieve records from the database is put together. This event can be used to modify the different clauses that make up the query such as the WHERE clause or the ORDER BY clause. |
Before Execute Select | This event occurs immediately before a row selection query is executed but after the query has been composed. This event can be used to modify the entire query before it is executed. |
After Execute Select | This event occurs after the row selection query has been executed and a recordset containing the results is returned. |
Client Side Events | |
On Change | Occurs on the client side whenever the control's value is changed and focus is lost. |
On Load | Used for binding Validation rules to control. A user can provide JavaScript code that will be executed by the browser. |
Property | Description |
---|---|
DataSource | A Data Source object created for the purpose of retrieving and holding the IDs and values to be displayed in the control. |
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. |
Recordset | This property contains object’s recordset used to iterate rows in the data source result. |
Value | This property contains the value of the selected ListBox option. |
Visible | This property determines whether the control is visible or not. |
Property | Description |
---|---|
DataSource.SQL | This property contains the main portion of the SQL query used to retrieve the records displayed within the control. 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 control. 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 control. |
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 | A Data Source object created for the purpose of retrieving the IDs and values to be displayed in the List Box control. |
Errors | An object that contains the error messages generated during script execution when submitted data fails verification or any other user defined condition is not fulfilled. |
Visible | This property determines whether the control is visible or not. |
Property | Description |
---|---|
DataSource->SQL | This property contains the main portion of the SQL query used to retrieve the records displayed within the control . 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 control. 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 control. |
Property | Description |
---|---|
Items | Gets the collection of items in the list control. See the .NET Framework SDK reference. |
SelectedIndex | Gets or sets the lowest ordinal index of the selected items in the list. See .NET Framework SDK reference. |
Value | Gets the value of the selected item in the HtmlSelect control or sets the SelectedIndex property of the control to the index of the first item in the list with the specified value. See .NET Framework SDK reference. |
Visible | This property determines whether the control is visible or not. |
Property | Description |
---|---|
<control name> | Contains the current value of the control. |
<control name>Items | This is a Collection of the control items. |
Method | Description |
---|---|
GetValue | Retrieves the value of the List Box control. |
SetValue | Sets the value of the List Box control. |
Variable | Description |
---|---|
arr_<owner name><control name> | This variable contains the array of items in the list control. |
fld<control name> | Holds the value of the List Box control. This variable can contain a semicolon separated list of values. |
hide<control name> | This variable determines whether the control is to be shown or not. |
strOrder<control name> | This property 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<control name> property to create the final SQL query which is executed against the datasource to retrieve the records for the control. |
strSQL<control name> | This property contains the main portion of the SQL query used to retrieve the records displayed within the control. In terms of SQL, this property defines the SELECT and FROM clauses of the SQL query. |
strWhere<control name> | This property contains the WHERE clause portion of the SQL query used to retrieve records for the control. The WHERE clause provides the criteria which filters the records retrieved. The value of this property is appended to the value of the strSQL<control name> property to create the final SQL query which is executed against the datasource to retrieve the records for the control. |
hide<control name> | This variable controls the visibility of the control. If the variable is set to true, the control will not be displayed. |
Method | Description |
---|---|
getOptionsString | Prepare HTML output for ListBox. The output consists of list of html option elements ready for output. |
addValue | In the case where the ListBox allows for the selection of multiple values, this function is used to add a value to the list of selected values. |
setValues | Set the list of selected values from an enumeration of Strings. |
setListOfValues | Set the list of values to choose from. Used to populate list values from a String. |
getOptions | Get the options list in the form of an enumeration of Strings. |
setOptions | Set the list of values to choose from. Used to populate list values from a String. |
getFormattedOptions | Prepare list collection for output. This method marks those list values that were selected by request. |
getPage | Get the page that contains this control. |
getFormattedValue | Get the value formatted according to the control format. |
setFormattedValue | Set the control value from String. Value is taken as is, formatting will not be applied to this value. |
hasErrors | Indicates whether the control has (validation) errors. |
addError | Add an error description to the errors collection. |
getErrorsAsString | Return a single String with all the error messages separated by <br> tags. |
isVisible | Returns a value indicating whether this control should be displayed or not. |
setVisible | Specify whether this control should be shown. |
getParent | Get the parent component that contains this control. |