世俱杯 2025

上一讲跟大家介绍了如何在 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线下研修班火热报名中！