TdxBackendDatabaseSQLConnection Class

A component designed to fetch data from an SQL database (SQL Server, PostgreSQL, SQLite, etc.).

Declaration

TdxBackendDatabaseSQLConnection = class(
    TdxBackendCustomDataConnection
)

Remarks

A data connection component allows you to bind a TdxReport or TdxDashboardControl component to data.

Main API Members

The list below outlines key members of the TdxBackendDatabaseSQLConnection class. These members allow you to configure data connection strings.

Data Connection Strings

Active: Specifies if the data connection is active.
DisplayName: Specifies the data connection’s name in both designer and Collection Editor dialogs.
ConnectionString: Specifies a connection string.

Tip
The TdxBackendDatabaseSQLConnection component relies on our ASP.NET Core Reporting engine (based on the XPO ORM powered by ADO.NET). Refer to the following topic for connection string examples: Specify a Connection String.

General-Purpose API Members

Collection | Index: Specify the parent collection component.

Indirect TdxBackendDatabaseSQLConnection Class References

The following public API members reference the TdxBackendDatabaseSQLConnection class as a TdxBackendCustomDataConnection object:

TdxBackendDataConnectionCollection.Add: Creates a data connection of the required type and ads the connection to the collection.
TdxBackendDataConnectionCollection.Items: Provides indexed access to all data connection components stored in the collection.
TdxBackendDataConnectionManager.Items: Provides indexed access to stored data connection components.

Other Backend Data Connection Components

TdxBackendInMemoryJSONConnection: A component designed for interaction with data stored in memory.
TdxBackendDataSetJSONConnection: A component designed to fetch data from one or multiple datasets (TDataSet descendant instances).

To see TdxDashboardControl and TdxReport components in action, run BI Dashboards Designer/Viewer and Report Designer/Viewer demos in the VCL Demo Center installed with compiled VCL DevExpress demos. Click different items in the sidebar on the left to switch between demo features.

Download: Compiled VCL Demos

Tip

You can find full source code for installed compiled Report and Dashboard demos in the following folders:

%PUBLIC%\Documents\DevExpress VCL Demos\MegaDemos\Product Demos\ExpressReports\
%PUBLIC%\Documents\DevExpress VCL Demos\MegaDemos\Product Demos\ExpressDashboards\