void OnConfigureConnectionStringSettings(object sender, EventArgs notUsed) { DbConfigurationMode configMode = (CreateNewDbRadioButton.Checked) ? DbConfigurationMode.Create : DbConfigurationMode.Configure; Button senderButton = (Button)sender; if (senderButton == buttonCreateOptions) { configMode = DbConfigurationMode.Create; } using (ConnectionConfigurationDlg config = new ConnectionConfigurationDlg( )) { ConfigurationOptions configuration = (ConfigurationOptions)senderButton.Tag; ConnectionStringSettings connectionSettings; connectionSettings = GetConnectionConfiguration(configuration); config.connectionConfigurationControl.DefaultSqlCeDatabaseName = Path.ChangeExtension(Path.Combine(GetFolderPath( ), configuration.DefaultDatabaseName), "sdf"); config.connectionConfigurationControl.DefaultSqlServerDatabaseName = configuration.DefaultDatabaseName; config.Title = GetDatabaseConfigHeaderMessage(configuration, configMode); if (!string.IsNullOrEmpty(connectionSettings.ConnectionString)) { config.connectionConfigurationControl.SetConnectionString(connectionSettings.ConnectionString, connectionSettings.ProviderName); } else { // config.connectionConfigurationControl.ClearConnectionString ( ) ; string connectionString; if (DefaultSqlConnectionStringBuilder == null) { connectionString = GetSqlCEDatabaseConnection(configuration.DefaultDatabaseName); config.connectionConfigurationControl.SetConnectionString(connectionString, ConnectionProviders.SqlCeProvider.Name); } else { connectionString = GetLocalSqlDefaultConnectionString(DefaultSqlConnectionStringBuilder, configuration.DefaultDatabaseName); config.connectionConfigurationControl.SetConnectionString(connectionString, ConnectionProviders.SqlServerProvider.Name); } } config.connectionConfigurationControl.Mode = configMode; if (DialogResult.OK == config.ShowDialog(this)) { connectionSettings.ConnectionString = config.connectionConfigurationControl.ConnectionString; connectionSettings.ProviderName = config.connectionConfigurationControl.DataProvider; configuration.ConnectionSettings = connectionSettings; string configText = config.connectionConfigurationControl.ConnectionString.MaskPassword(); SetLabelText(configuration.ConfigurationLabel, configText); } } }
public static void ChooseDefaultSqlServer() { using (ConnectionConfigurationDlg config = new ConnectionConfigurationDlg()) { } }