Please be advised that this ComponentOne software tool is accompanied by various sample projects and/or demos which may make use of other development tools included with ComponentOne Studio Enterprise.
Sample |
Description |
---|---|
CalcFields |
This sample demonstrates how to use Field.Expression property to change calculated field expressions at run time. This sample uses the C1Query and C1QueryFrame controls. |
ChangeEvent |
This sample demonstrates how to use the C1QueryFrame_Change event to detect any modification made to a query. This sample uses the C1Query and C1QueryFrame controls. |
Checkboxes |
This sample demonstrates the checkbox feature: setting C1QueryFrame.Checkboxes to True displays a checkbox in query condition items (Conditions tab in the sample). A checkbox determines whether an item is included in the resulting SQL statement. This sample uses the C1Query and C1QueryFrame controls. |
CustomComparisons |
This sample shows how to add custom comparison operators to template file and dynamically at run time. The template file comparisons.tpl contains a custom comparison "!=" (appears in the control in the end of the comparison menu). The template file was loaded into the control using "Load Templates" in the control's context menu. The Add button adds a comparison operator dynamically, at run time. This sample uses the C1Query and C1QueryFrame controls. |
CustomComparisons2 |
This sample demonstrates how to handle special situations that can arise in connection with custom comparison operators. This sample uses the C1Query and C1QueryFrame controls. |
CustomEdit |
This sample demonstrates custom editing. Uses a text box and an UpDown button in a PictureBox container. This sample uses the C1Query and C1QueryFrame controls. |
CustomFunctions |
This sample shows how to add custom functions to template file and dynamically at run time. Functions appear in the field "function:" of a result field query item. This sample uses the C1Query and C1QueryFrame controls. |
CustomMenu |
This sample demonstrates how to use BeforeMenu and AfterMenu events, and also how to set the constant value in a condition to a certain default value when the user selects a field in this condition. This sample uses the C1Query and C1QueryFrame controls. |
CustomUI |
This sample shows how C1Query can be used with custom UI built with Visual Basic controls without using the built-in UI, C1QueryFrame. This sample uses the C1Query and C1QueryFrame controls. |
DAO |
This sample demonstrates how to use C1Query with database connections other than ADO/OLE DB. This sample uses the C1Query and C1QueryFrame controls. |
ErrorHandling |
This sample demonstrates error handling and changing edited value to a programmatically defined value in the EndEdit event. This sample uses the C1Query and C1QueryFrame controls. |
GetItemIDAt |
This sample demonstrates the GetItemIDAt method allowing the user to locate a query item given point coordinates. This sample uses the C1Query and C1QueryFrame controls. |
IntelliLookup |
This sample demonstrates how C1Query custom editing and lookup features can be used to build a sophisticated user interface enhancement modeled after Internet Explorer IntelliSense feature. This sample uses the C1Query and C1QueryFrame controls. |
Item_Alias |
This sample demonstrates the QueryItem.Alias property allowing the user to specify the alias (column name) of a result field in the resulting SQL statement.This sample uses the C1Query and C1QueryFrame controls. |
Item_ComparisonAttr |
This sample demonstrates the QueryItem.ComparisonAttributes property allowing to change item comparison operation at run time ("on the fly"), both in the query and in the resulting SQL statement. Any comparisons can be used, including non-standard, custom comparisons. This sample uses the C1Query control. |
Item_FuncAttr |
This sample demonstrates the QueryItem.FunctionAttributes property allowing to change a result field item's function at run time ("on the fly"), both in the query and in the resulting SQL statement. Any functions can be used, including non-standard, custom functions. This sample uses the C1Query control. |
ItemFocusChange |
This sample shows how to detect changes using the AfterEdit and AfterMenu events, and how to react to current row (item) change using the ItemFocusChange event.This sample uses the C1Query and C1QueryFrame controls. |
ModalEditing |
This sample demonstrates modal editing. Select the CategoryID field and click the value. A modal dialog box will open, where you can select a category ID. The sample uses BeforeEdit and EndEdit events. This sample uses the C1Query and C1QueryFrame controls. |
Repository |
This sample demonstrates how you can store queries and their descriptions in a repository, load, save and execute them. This sample uses the C1Query and C1QueryFrame controls. |
RunTimeSchemaInit |
This sample shows how to create and use a schema at run time without using Schema Designer. |
SetLookUp |
This sample shows how to use the SetLookup method to retrieve lookup lists from database. Run the sample and select the CustomerID field. This sample uses the C1Query and C1QueryFrame controls. |
SetTemplateAttribute |
This sample shows how to change various display attributes at run time. This sample uses the C1Query and C1QueryFrame controls. |
ShowFolderFields |
This sample shows how to hide/show fields at run time. |
SQLGenerationItem |
This sample shows how to use the SQLGenerationitem event to dynamically change the collection of items while C1Query generates an SQL statement. This sample uses the C1Query and C1QueryFrame controls. |
TDBCombo |
This sample uses ComponentOne True DBCombo control for selection from a lookup value list. In this sample, you need ComponentOne True DBList 8.0 product installed on your machine. Lookup lists based on a database table can be implemented with just one line of code using the SetLookup method. SetLookup retrieves all the data from the database at once. ComponentOne TDBCombo control does this much more efficiently, fetching data only when needed. Run the sample and select the CustomerID field. Click the value, then you will be able to select from a combo box filled with company names. |
ValueFormatting |
This sample loops through all query items and formats all date values to long or short dates according to a check box value. This sample uses the C1Query and C1QueryFrame controls. |