Skip to main content

SqlWizardSettings.DatabaseCredentialsSavingBehavior Property

Specifies whether to serialize database credentials along with document layouts (for example, a report or dashboards). Optionally, you can enable your end users to select the required behavior.

Namespace: DevExpress.DataAccess.UI.Wizard

Assembly: DevExpress.DataAccess.v24.1.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap

Declaration

[DefaultValue(SensitiveInfoSavingBehavior.Never)]
public SensitiveInfoSavingBehavior DatabaseCredentialsSavingBehavior { get; set; }

Property Value

Type Default Description
SensitiveInfoSavingBehavior Never

A SensitiveInfoSavingBehavior enumeration value.

Available values:

Name Description
Always

Database credentials are always serialized along with document layouts and end-users cannot change this behavior.

Never

Database credentials are never serialized along with document layouts and end-users cannot change this behavior.

Prompt

After an existing connection is selected (or a new one is specified), the Data Source wizard prompts an end-user whether or not to save database credentials along with the document layout.

Property Paths

You can access this nested property as listed below:

Library Object Type Path to DatabaseCredentialsSavingBehavior
WinForms Controls DataSourceWizardSettings
.SqlWizardSettings .DatabaseCredentialsSavingBehavior
Dashboard DashboardDesignerDataSourceWizardSettings
.SqlWizardSettings .DatabaseCredentialsSavingBehavior
.NET Reporting Tools XRDesignMdiController
.SqlWizardSettings .DatabaseCredentialsSavingBehavior

Remarks

Enable the DataConnectionBase.StoreConnectionNameOnly property when you implement the IConnectionStorageService interface to serialize database connection names only. This behavior does not expose database credentials in report layout definitions.

View Example: Reporting for WinForms - How to Store Connections Available in the Data Source Wizard

When the StoreConnectionNameOnly property is disabled, the behavior depends on the DatabaseCredentialsSavingBehavior and IConnectionStorageService.CanSaveConnection property values.

SensitiveInfoSavingBehavior

Behavior

Prompt

Always or Never

Users cannot specify whether to store database credentials with serialized layouts. After they select a connection or specify a new one, the Data Source Wizard displays the following page:

The following code snippet shows how to specify SQL Wizard settings when you invoke the End-User Report Designer using the ReportDesignTool class methods:

using DevExpress.XtraReports.UI;
// ...
ReportDesignTool designer = new ReportDesignTool(new XtraReport());
designer.DesignRibbonForm.DesignMdiController.DataSourceWizardSettings.
    SqlWizardSettings.DatabaseCredentialsSavingBehavior =  
    DevExpress.DataAccess.Wizard.SensitiveInfoSavingBehavior.Never;
designer.ShowRibbonDesigner();
See Also