DataConnectionBase.Open() Method

Opens the data connection session.

Namespace: DevExpress.DataAccess

Assembly: DevExpress.DataAccess.v22.2.dll

NuGet Package: DevExpress.DataAccess

Declaration

C#

public void Open()

VB.NET

Public Sub Open

Example

In this example, the TableQuery.GetSql method is used to obtain the query string that is used to fetch data from the connected data source.

Prior to using this method, open the corresponding data connection by calling the DataConnectionBase.Open method of the SqlDataConnection class.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/Reporting_how-to-obtain-the-sql-string-that-has-been-automatically-constructed-for-a-table-t188966

XtraReport1.cs

using System;
using DevExpress.DataAccess.ConnectionParameters;
using DevExpress.DataAccess.Sql;
using DevExpress.XtraReports.UI;
// ...
        private void XtraReport1_DataSourceDemanded(object sender, EventArgs e) {
            // Create a new SQL data source and specify its connection parameters.
            var sqlDataSource = new SqlDataSource(new Access97ConnectionParameters() {
                FileName = @"..//..//nwind.mdb"
            });

            // Create a query and assign it to the data source.
            SelectQuery query = SelectQueryFluentBuilder
                .AddTable("Categories")
                .SelectColumns("CategoryID", "CategoryName")
                .Build("MyQuery");
            sqlDataSource.Queries.Add(query);

            // Open the connection to the data source.
            sqlDataSource.Connection.Open();

            // Obtain the database schema of the connected data source.
            var sql = query.GetSql(sqlDataSource.Connection.GetDBSchema());

            // Assign the data source to the report.
            this.DataSource = sqlDataSource;
            this.DataMember = "MyQuery";
        }

XtraReport1.vb

Imports System
Imports DevExpress.DataAccess.ConnectionParameters
Imports DevExpress.DataAccess.Sql
Imports DevExpress.XtraReports.UI
' ...
        Private Sub XtraReport1_DataSourceDemanded(ByVal sender As Object, ByVal e As EventArgs) Handles MyBase.DataSourceDemanded
            ' Create a new SQL data source and specify its connection parameters.
            Dim sqlDataSource = New SqlDataSource(New Access97ConnectionParameters() With {.FileName = "..//..//nwind.mdb"})

            ' Create a query and assign it to the data source.
            Dim query As SelectQuery = SelectQueryFluentBuilder.AddTable("Categories").SelectColumns("CategoryID", "CategoryName").Build("MyQuery")
            sqlDataSource.Queries.Add(query)

            ' Open the connection to the data source.
            sqlDataSource.Connection.Open()

            ' Obtain the database schema of the connected data source.
            Dim sql = query.GetSql(sqlDataSource.Connection.GetDBSchema())

            ' Assign the data source to the report.
            Me.DataSource = sqlDataSource
            Me.DataMember = "MyQuery"
        End Sub

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Open() method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

Reporting_how-to-obtain-the-sql-string-that-has-been-automatically-constructed-for-a-table-t188966/CS/TableQueryGetSql/XtraReport1.cs#L30

// Open the connection to the data source.
sqlDataSource.Connection.Open();

Reporting_wpf-end-user-report-designer-how-to-create-a-custom-data-source-wizard-t286514/CS/Custom Wizard/Data Wrapper Classes/DataSourceWrapper.cs#L113

try {
    testDS.Connection.Open();
} catch(Exception e) {

VB.NET

Reporting_how-to-obtain-the-sql-string-that-has-been-automatically-constructed-for-a-table-t188966/VB/TableQueryGetSql/XtraReport1.vb#L27

' Open the connection to the data source.
sqlDataSource.Connection.Open()

Reporting_wpf-end-user-report-designer-how-to-create-a-custom-data-source-wizard-t286514/VB/Custom Wizard/Data Wrapper Classes/DataSourceWrapper.vb#L115

Try
    testDS.Connection.Open()
Catch e As Exception