private void CompleteBoxes() { ConfigurationManager.RefreshSection("combit.RedmineReports.Properties.Settings.RedmineConnectionString"); string convertString = ConfigurationManager.ConnectionStrings["combit.RedmineReports.Properties.Settings.RedmineConnectionString"].ConnectionString; if (RedmineReportsConfigDataHelper.ConnectionStringEncrypted(convertString)) { //decrypt connectionstring convertString = RedmineReportsConfigDataHelper.DecryptData(convertString); } Match m = Regex.Match(convertString, "server=([^;]*);uid=([^;]*);pwd=([^;]*);database=([^;]*);port=([^;]*);"); ipAddressTextBox.Text = m.Groups[1].Value; mySQLLogTextBox.Text = m.Groups[2].Value; mySQLPasssTextBox.Text = m.Groups[3].Value; dbNameTextBox.Text = m.Groups[4].Value; mySqlPortTextBox.Text = m.Groups[5].Value; }
public RedmineMySqlDataAccess(string ConnectionString) { // create connection _connection = new MySqlConnection(); if (String.IsNullOrEmpty(ConnectionString)) { string convertString = ConfigurationManager.ConnectionStrings["combit.RedmineReports.Properties.Settings.RedmineConnectionString"].ConnectionString; //decrypt connectionstring _connection.ConnectionString = RedmineReportsConfigDataHelper.DecryptData(convertString); } else { _connection.ConnectionString = ConnectionString; } try { _connection.Open(); } catch (MySqlException ex) { MessageBox.Show(ex.Message); } }