TdxBackendDatabaseSQLConnection Class
A non-visual 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.
Supported Database Engines
VCL Backend implementation has built-in support for Microsoft SQL, Azure SQL, and SQLite database engines.
Tip
You can use the TdxBackendDatabaseSQLConnection component to connect TdxDashboardControl and TdxReport components to these databases without additional dependencies and extra configuration.
Other Supported Database Engines
In addition, you can use the TdxBackendDatabaseSQLConnection component to connect your application that is powered by ExpressReports or ExpressDashboards to PostgreSQL, MySQL, Oracle, and Firebird databases. These engines require corresponding database provider assemblies within the dotnet_libraries folder of the app executable repository.
Refer to the following help topic for a complete list of supported database engines, corresponding provider assemblies, connection string examples, and related instructions: VCL Backend: Supported Database Systems.
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. Enable this property to connect the component to an SQL database using the current connection string.
- DisplayName
- Specifies the data connection’s name in both designer and Collection Editor dialogs.
- ConnectionString
- Specifies a connection string for a supported database engine.
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).
Related Compiled Demos
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.
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\