Using the included samples with different databases

.netCHARTING 3.4 and earlier include integrated support for MS Access and MS SQL Server and also support the ability to pass nearly all .NET data structures (e.g. datatable, dataset, dataview etc) to the Data property.  For more information on database support please see the documentation under "getting started," "data tutorials."

The .NET 2.0 version of .netCHARTING 4.0 added additional native support for other database types including MySQL and Oracle and the full sample set can now be used with MS Access (default), MS SQL Server, MySQL or Oracle.

For details on how to setup the samples and create the required sample database for your database of choice please see the /database folder included in the bundle.  This folder includes sub-folders for MySQL, Oracle and Sqlserver. Each folder includes a readme.txt with database specific instructions for usage and a database creation script.

The default connection string for all samples is defined in the global.asa to enable you to easily change it without individually editing all included samples.  The global.asa also includes sample connection strings for the other seamlessly supported database types which by default are commented out. 

Note: If you are not using a connection string in the provided sample format as shown in the global.asa, you may also need to specify the DataProviderType with the following line:

Chart.DefaultSeries.DataProviderType = DataProviderType.Oracle;

DataProviderType options include:

In Framework 2.x .netCHARTING 4.0 and later:
MsSql, OleDb, MsAccess, MySql, Oracle, and Odbc.

In all other versions of .netCHARTING:
MsSql, OleDb, and MsAccess.

The DataProviderType property is optional and only needs to be set if your connection string is ambigous.  For example, if you see an error regarding SQL server when attempting to work with an Oracle connection string please set the DataProviderType property to resolve your issue.

DataTypeProvider is supported in all DataEngine related properties including:
Chart.DefaultSeries.DataProviderType = DataProviderType.Oracle;
Chart.Series.DataProviderType = DataProviderType.Oracle;
DE.Series.DataProviderType = DataProviderType.Oracle;

Posted Monday, October 2, 2006 by Support