Use this sample if you want to connect to the Oracle Data Provider, which is otherwise not available since System.Data.OracleClient is deprecated.

Sample Location

Visual Basic.NET

..\Samples14\Advanced\PageAndRDL\OracleDataProvider\VB.NET

C#

..\Samples14\Advanced\PageAndRDL\OracleDataProvider\C#

Details

When you run this sample, a blank DesignerForm for RDL report is displayed. Connect to the Oracle data provider as follows:

1. Add a data source.
2. In the Report Datasource dialog, select Type as  Oracle Managed Data Access.
3. Enter the connection string.

   Sample Oracle Connection String

   data source=in-data-sql/orcl.grapecity.net;user id=user1;password=password@123;

Now, proceed the report designing by pulling the data from Oracle data provider.

The sample consists of following:

TestDesignerPro.csproj: This is the default start up project.

GrapeCity.ActiveReports.config: Located inside the startup project, it is a configuration file that contains the settings for using the oracle data provider:

• DisplayName to reference data provider and Type to use the oracle custom data provider as mandatory fields
• AdapterType implemented in 'OracleConnectionAdapter' class and SchemaProviderType implemented in 'GeneralOracleSchemaProvider' class for additional features.

OracleConnectionAdapter.cs: This class provides features related to parameters such as handling multi-value paramaters and parameterized queries.

GeneralOracleSchemaProvider.cs: This class generates DataSchema to enable visual query designer support.