TdxReportDatabaseSQLConnection.ConnectionString Property

Specifies a connection string.

Declaration

property ConnectionString: string read; write;

Property Value

Type	Description
string	The connection string.

Remarks

A connection string specifies the target database (SQL Server, PostgreSQL, SQLite, etc.) and all parameters required for connections.

Use the ConnectionString property to specify a connection string according to syntax described in the following topic:

Specify a Connection String

Code Example: Connect to an SQL Database and Edit Report Templates

The following code example uses the TdxReportDatabaseSQLConnection component to connect to a demo database (nwind.mdb), displays the Report Designer dialog, and saves all changes made to the UserReport.repx file:

Delphi

uses
  dxReport,  // Declares the TdxReport component and related types
  dxReport.ConnectionString.SQL;  // Declares the TdxReportDatabaseSQLConnection component
// ...

procedure TMyForm.Button1Click(Sender: TObject);
var
  ADataConnection: TdxReportDatabaseSQLConnection;
  AReport: TdxReport;
begin
  ADataConnection := TdxReportDatabaseSQLConnection.Create(Self);
  try
    ADataConnection.Name := 'DataConnection';
    // Specify a connection string required to connect to a demo database (nwind.mdb)
    ADataConnection.ConnectionString := 'XpoProvider=MSAccess;Provider=Microsoft.ACE.OLEDB.12.0;' +
      'Data Source=C:\Users\Public\Documents\DevExpress VCL Demos\' +
      'MegaDemos\Product Demos\ExpressPivotGrid\Data\nwind.mdb';
    AReport := TdxReport.Create(Self);
    try
      AReport.ShowDesigner;  // Displays the Web-based Report Designer dialog
      AReport.Layout.SaveToFile('UserReport.repx');  // Saves the report template state to a file
    finally
      AReport.Free;
    end;
  finally
    ADataConnection.Free;
  end;
end;

C++

#include "dxReport.hpp"  // Declares the TdxReport component and related types
#include "dxReport.ConnectionString.SQL.hpp"  // Declares the TdxReportDatabaseSQLConnection component

// Add the following linker directives to the corresponding CPP source file:
#pragma link "dxReport"  // Required to use dxReport.hpp declarations
#pragma link "dxReport.ConnectionString.SQL"  // Required to use TdxReportDatabaseSQLConnection declarations
// ...

void __fastcall TMyForm::Button1Click(TObject *Sender)
{
  TdxReportDatabaseSQLConnection *ADataConnection;
  TdxReport *AReport;
  ADataConnection = new TdxReportDatabaseSQLConnection(this);
  try
  {
    ADataConnection->Name = "DataConnection";
    // Specify a connection string required to connect to a demo database (nwind.mdb)
    ADataConnection->ConnectionString = "XpoProvider=MSAccess;Provider=Microsoft.ACE.OLEDB.12.0;"
      "Data Source=C:\\Users\\Public\\Documents\\DevExpress VCL Demos\\MegaDemos\\"
      "Product Demos\\ExpressPivotGrid\\Data\\nwind.mdb";
    AReport = new TdxReport(this);
    try
    {
      AReport->ShowDesigner();  // Displays the Report Designer dialog
      AReport->Layout->SaveToFile("UserReport.repx");  // Saves the report template state to a file
    }
    __finally
    {
      delete AReport;
    }
  }
  __finally
  {
    delete ADataConnection;
  }
}

Default Value

The ConnectionString property’s default value is an empty string.