ChartDirector 6.0 (ASP/COM/VB Edition)

Database Sample Code Overview


All ChartDirector database sample scripts described in this documentation are based on the sample database in "[Chartdirector]\aspdemo\sample.mdb" ([ChartDirector] = directory where ChartDirector is installed).

The "sample.mdb" is a MS Access database that contains only one table called "Revenue" . The table stores the monthly revenue data for three business units - Hardware, Software and Services. It contains four columns as follows:

Column NameType
TimeStampDate/Time
HardwareNumber
SoftwareNumber
ServicesNumber

Each row in the database table contains monthly revenues for the business units, where the date is stored in the "TimeStamp" column. The sample database contains rows from Jan 1990 to Dec 2001.

To run the sample scripts, Microsoft Advanced Data Objects (ADO Ver 2.0 or above) is required. Most Microsoft operating systems already have this component installed. However, if your system does not have ADO Ver 2.0 or above, you can download the latest Microsoft Data Access Components (which includes ADO) from Microsoft.