Table of Contents

FlexCelReport.AddConnection Method

Overloads

FlexCelReport.AddConnection(String, IDbDataAdapter, CultureInfo)

Adds an adapter to use from the template on the DIRECT SQL commands. For security reasons, make sure this adapter ONLY GRANTS READONLY ACCESS TO THE DATA

Syntax

Namespace: FlexCel.Report

public void AddConnection(String connectionName, IDbDataAdapter adapter, CultureInfo locale)

Parameters

<-> Parameter Type Description
connectionName String This is the name you will use on the template to refer to this adapter.
adapter IDbDataAdapter The adapter that will be used.
locale CultureInfo The locale for the created tables.

See also

FlexCelReport.AddConnection(String, IDbDataAdapter, CultureInfo, Boolean)

Adds an adapter to use from the template on the DIRECT SQL commands. For security reasons, make sure this adapter ONLY GRANTS READONLY ACCESS TO THE DATA

Syntax

Namespace: FlexCel.Report

public void AddConnection(String connectionName, IDbDataAdapter adapter, CultureInfo locale, Boolean caseSensitive)

Parameters

<-> Parameter Type Description
connectionName String This is the name you will use on the template to refer to this adapter.
adapter IDbDataAdapter The adapter that will be used.
locale CultureInfo The locale for the created tables.
caseSensitive Boolean When true strings will be case sensitive, and "a" will be different from "A"

See also

FlexCelReport.AddConnection(String, IDbCommand, CultureInfo, Boolean)

Adds an SQL command to use from the template on the DIRECT SQL commands. For security reasons, make sure this adapter ONLY GRANTS READONLY ACCESS TO THE DATA

Remarks

You will usually want to use AddConnection(String, IDbDataAdapter, CultureInfo) instead. This method is provided for the cases where there is no DataAdapter in the technology you are using. (as is currently the case with Microsoft.Data.SQLite)

Syntax

Namespace: FlexCel.Report

public void AddConnection(String connectionName, IDbCommand command, CultureInfo locale, Boolean caseSensitive)

Parameters

<-> Parameter Type Description
connectionName String This is the name you will use on the template to refer to this command.
command IDbCommand The select command that will be used.
locale CultureInfo The locale for the created tables.
caseSensitive Boolean When true strings will be case sensitive, and "a" will be different from "A"

See also