public string Conect() { String password = Cryption.DecryptRijndael(mysettings.Default.password); string dbconnection_gabinet = "datasource=" + mysettings.Default.datasource + ";database=" + mysettings.Default.database + ";port=" + mysettings.Default.port + ";username="******";password="******";charset=utf8"; return(dbconnection_gabinet); }
private void toolStripButton4_Click(object sender, EventArgs e) { try { String password = Cryption.DecryptRijndael(mysettings.Default.password); Database database = new Database(); string constring = "server=" + mysettings.Default.datasource + ";user="******";pwd=" + password + ";database=" + mysettings.Default.database + ";"; string file = @"C:\Baza\backup.sql"; using (MySqlConnection conn = new MySqlConnection(constring)) { using (MySqlCommand cmd = new MySqlCommand()) { using (MySqlBackup mb = new MySqlBackup(cmd)) { cmd.Connection = conn; conn.Open(); mb.ExportToFile(file); conn.Close(); } } } MessageBox.Show("Plik backup.sql został zapisany z powodzeniem!"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void Update_daneBaza() { this.textBoxAdres.Text = mysettings.Default.datasource; this.textBoxNazwa.Text = mysettings.Default.database; this.textBoxPort.Text = mysettings.Default.port; this.textBoxUser.Text = mysettings.Default.user; String password = Cryption.DecryptRijndael(mysettings.Default.password); this.textBoxPass.Text = password; }