DataSource Property

The Newlook Data Control creates a connection between inserted controls on your form and an external data source. Once a connection to the database is established (via the ConnectionString property of the Data control) then any control that is bound to the Data control automatically displays data from the specified field for the current record.

This property is used to bind the relevant control to an existing data control on your form. Enter the name of the data control that you wish to bind to in this property.

The DataField property then links the control to a specific field in the data source.

The Data control then performs operations on the current record and updates all controls bound to it.

BE AWARE THAT:

If the control is bound to a data source via the DataField and DataSource properties then any value specified in the Text property at Design-time will be ignored.

In the case of the Google Chart controls, the DataSourceproperty is used to specify source of data that you wish to represent in your chart.

A datagrid control can be set as the datasource by using the Field Picker tool () to select the relevant grid control or by typing in an expression using the Field function. Once specified, the value will be displayed in the property grid as =Field("FieldName") or =Field(<Row>,<Column>).

If you have OpenLook installed on your IBMi, the SQL function can be used to query a host database file directly and return the results of that query as the data source of your chart.

=SQL("Connection", "SQL Query")

Where Connection is an existing connection to your host, and SQL Statement is a valid SQL SELECT statement.