private void toolStripRestoreBackup_Click(object sender, EventArgs e) { string RestoreCommand = ""; string BackupFileName = ""; string Password = ""; OpenFileDialog DBBackupFile = new OpenFileDialog(); DBBackupFile.InitialDirectory = @"C:\"; DBBackupFile.Title = "Choose Backup File"; DBBackupFile.ShowReadOnly = true; if (DBBackupFile.ShowDialog() == DialogResult.OK) { BackupFileName = DBBackupFile.FileName; } FrmChoosePassword ChoosePassword = new FrmChoosePassword(); ChoosePassword.Font = this.Font; ChoosePassword.BackColor = Color.Teal; ChoosePassword.StartPosition = FormStartPosition.CenterScreen; var Res = ChoosePassword.ShowDialog(); if (Res == DialogResult.OK) { Password = ChoosePassword.ReturnValue; } RestoreCommand = "restore database ExMon from disk = '" + BackupFileName + "' with password = '******'"; try { CommFunc.Execute_DB_Command(RestoreCommand); } catch (Exception Ex) { MessageBox.Show("ERROR: " + Ex, "error:", MessageBoxButtons.OK); } }
private void toolStripBackupData_Click(object sender, EventArgs e) { string BackupCommand = ""; string BackupFileName = ""; string Password = ""; SaveFileDialog DBBackupFile = new SaveFileDialog(); DBBackupFile.InitialDirectory = @"C:\"; DBBackupFile.Title = "Choose Backup File"; if (DBBackupFile.ShowDialog() == DialogResult.OK) { BackupFileName = DBBackupFile.FileName; } if (BackupFileName != "") { FrmChoosePassword ChoosePassword = new FrmChoosePassword(); ChoosePassword.Font = this.Font; ChoosePassword.BackColor = Color.SteelBlue; ChoosePassword.StartPosition = FormStartPosition.CenterScreen; var Res = ChoosePassword.ShowDialog(); if (Res == DialogResult.OK) { Password = ChoosePassword.ReturnValue; } BackupCommand = "backup database ExMon to disk = '" + BackupFileName + "' with password = '******'"; CommFunc.Execute_DB_Command(BackupCommand); } }