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;
}
