Dotco Software
 

When you create a page, or add a control to a page, both of these have a property item in the properties window called DataSource. By clicking on the button here, this will allow you to create a data source for it.

To create a page, the main data source that is created is usually a SELECT statement, which retrieves information from a database, usually one record at a time, and can be displayed on the current page. The way to do this is also with the properties.

When the data source is set for the page you want to display information in, then you can click on each of the controls on the page, and they all have a property called DataField. This is a drop-down list that is populated with all the fields that have selected for the page data source, therefore allowing you to assign each field to a control.

These are the general data source wizard screens you will use for most of the controls.See the images below:

Step 1 - Create New or Use Existing Data Source.

 

Step 2 - Select the Type of SQL Statement.

 

Step 3 - Select the Table or View from which you want to get data.

 

Step 4 - Alternatively, you can use the Advanced Builder to create a complex query.

 

Step 5 - Select any fields you wish to use as a data filter for your page (eg. filter by PostalCode),

 

Step 6 - Give the DataSource a Name, and you are done.

Copyright 2008, Dotco Software Ltd. All Rights Reserved.