private void SetupConnectionString(DashboardConfigureDataConnectionEventArgs e) { // There is a duplicate code in Module.Web too.. Dont forget to change it. var connectionStringSettings = ConfigurationManager.ConnectionStrings[e.ConnectionName]; ConnectionStringParser parser; if (connectionStringSettings != null) { parser = new ConnectionStringParser(connectionStringSettings.ConnectionString); } else { parser = new ConnectionStringParser(Application.ConnectionString); } var connectionParameters = e.ConnectionParameters as CustomStringConnectionParameters; if (connectionParameters != null && connectionParameters.ConnectionString.Contains("XpoProvider=MSSqlServer")) // SqlServer { var sqlConnectionParameters = new MsSqlConnectionParameters(); sqlConnectionParameters.ServerName = !string.IsNullOrWhiteSpace(parser.GetPartByName("Data Source")) ? parser.GetPartByName("Data Source") : parser.GetPartByName("Server"); sqlConnectionParameters.DatabaseName = parser.GetPartByName("Initial Catalog"); sqlConnectionParameters.AuthorizationType = parser.GetPartByName("Integrated Security").ToLower() == "true" ? MsSqlAuthorizationType.Windows : MsSqlAuthorizationType.SqlServer; sqlConnectionParameters.UserName = parser.GetPartByName("User ID"); sqlConnectionParameters.Password = parser.GetPartByName("Password"); e.ConnectionParameters = sqlConnectionParameters; } }
private void dashboardViewer1_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e) { if (e.DataSourceName == "SQL Data Source 1") { e.ConnectionParameters = new Access97ConnectionParameters(@"..\..\Data\nwind.mdb", "", ""); } }
private void ConfigureDataConnection(DashboardConfigureDataConnectionEventArgs e) { if (e.ConnectionName == "GlobalSales_XCRM") { e.ConnectionParameters = SqlDashboardHelper.GetSqlParameters(ObjectSpace); } }
private void DashboardViewer1_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e) { if (e.DataSourceName == "SalesPerson") { ((ExcelDataSourceConnectionParameters)e.ConnectionParameters).FileName = @"Data\SalesPerson.xlsx"; } }
private void ConfigureDataConnection(DashboardConfigureDataConnectionEventArgs e) { // ToDo: Complete the connection string resolving process. 2F4D197A-9BF1-4DEE-A1DC-52447F969889 // Detail link: https://www.devexpress.com/Support/Center/Question/Details/T473885 SetupConnectionString(e); }
private void ConfigureDataConnection(DashboardConfigureDataConnectionEventArgs e) { if (e.ConnectionName == "GlobalSales_XCRM") { e.ConnectionParameters = new MsSqlConnectionParameters(); SqlDashboardHelper.SetupSqlParameters(ObjectSpace, (MsSqlConnectionParameters)e.ConnectionParameters); } }
private void dashboardViewer1_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e) { ExtractDataSourceConnectionParameters parameters = e.ConnectionParameters as ExtractDataSourceConnectionParameters; if (parameters != null) { parameters.FileName = Path.GetFileName(parameters.FileName); } }
private void dashboardControl1_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e) { CustomStringConnectionParameters parameters = e.ConnectionParameters as CustomStringConnectionParameters; if (e.DataSourceName == "MySqlDataSource") { parameters.ConnectionString = @"XpoProvider=MSSqlServer;Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\NWind.mdf;Integrated Security=True"; } }
private void dashboardViewer1_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e) { if (e.DataSourceName == "SQL Data Source 1") { Access97ConnectionParameters parameters = (Access97ConnectionParameters)e.ConnectionParameters; parameters.UserName = "******"; parameters.Password = "******"; } }
private void DashboardViewer_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e) { switch (DBManager.PrimaryDBManagerType) { case DBManagerType.MySql: e.ConnectionParameters = new MySqlConnectionParameters(DBManager.InitDatabaseServer, DBManager.InitDatabaseName, DBManager.InitDatabaseID, DBManager.InitDatabasePass, 3306); break; case DBManagerType.SQLServer: e.ConnectionParameters = new MsSqlConnectionParameters(); break; } }
private void Dashboard1_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e) { if (e.DataSourceName == "SQL Data Source 1") { // Gets connection parameters used to establish a connection to the database. Access97ConnectionParameters parameters = (Access97ConnectionParameters)e.ConnectionParameters; string databasePath = @"..\..\Data\nwind.mdb"; // Specifies the path to a database file. parameters.FileName = databasePath; } }
private void DashboardViewer_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e) { if (e.ConnectionParameters is ExtractDataSourceConnectionParameters extractParameters) { if (Guid.TryParse(extractParameters.FileName, out var id)) { var extract = ObjectSpace.GetObjectByKey <DashboardDataExtract>(id); if (extract != null) { extract.ConfigureConnectionParameters(extractParameters); } } } }
private void DashboardViewer_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e) { if (e.ConnectionParameters is ExtractDataSourceConnectionParameters extractParameters) { if (Guid.TryParse(extractParameters.FileName, out var id)) { var extract = DashboardHelper.GetDataExtract(Application, ObjectSpace, id); if (extract != null) { extract.ConfigureConnectionParameters(Application, extractParameters); } } } }
private void DashboardViewer_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e) { try { switch (DBManager.PrimaryDBManagerType) { case DBManagerType.MySql: e.ConnectionParameters = new MySqlConnectionParameters(DBManager.InitDatabaseServer, DBManager.InitDatabaseName, DBManager.InitDatabaseID, DBManager.InitDatabasePass, 3306); break; case DBManagerType.SQLServer: e.ConnectionParameters = new MsSqlConnectionParameters(); break; } } catch (ExceptionManager pExceptionManager) { CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager)); } }
private void DashboardViewer1_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e) { ExtractDataSourceConnectionParameters connParameters = e.ConnectionParameters as ExtractDataSourceConnectionParameters; connParameters.FileName = "Data\\SalesPerson.dat"; }
private void Viewer_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e) { ConfigureDataConnection(e); }