上一講跟大家介紹了如何在 DevExpress Dashboard 中繪制Ribbon UI。本文將為你展示如何在DashboardViewer連接到數據庫之前使用DashboardViewer.ConfigureDataConnection事件自定義連接設置。

這里，儀表盤的XML定義包含一個連接到Microsoft Access數據庫的路徑。如果想讓數據庫文件中的數據可視，則必須提供連接參數，尤其是用戶名和密碼。DashboardViewer.ConfigureDataConnection事件的目的也在于此，它的 Access97ConnectionParameters.UserName 和 FileConnectionParametersBase.Password參數分別用于設置用戶名和密碼。

請參考以下代碼：

using System.Windows.Forms;
using DevExpress.DataAccess.ConnectionParameters;

namespace Dashboard_ConfigureDataConnection {
public partial class Form1 : Form {
public Form1() {
InitializeComponent();

// Loads a dashboard from an XML file.
dashboardViewer1.LoadDashboard(@"..\..\Data\nwindDashboard.xml");
}

// Handles the ConfigureDataConnection event.
private void dashboardViewer1_ConfigureDataConnection(object sender,
DevExpress.DataAccess.ConfigureDataConnectionEventArgs e) {

// Checks the name of the connection for which the event has been raised.
if (e.ConnectionName == "nwindConnection") {

// Gets the connection parameters used to establish a connection to the database.
Access97ConnectionParameters parameters =
(Access97ConnectionParameters)e.ConnectionParameters;

// Specifies the user name used to access the database file.
parameters.UserName = "Admin";

// Specifies the password used to access the database file.
parameters.Password = "password";
}
}
}
}

慧都學院2017全新DevExpress線下研修班火熱報名中！