private void btnOk_Click(object sender, RoutedEventArgs e) { cls.ClsConnect(); bll.TaoThuMuc(Thumuc); try { if (txtPath.Text == "") { MessageBox.Show("Chưa chọn đường dẫn", "Error", MessageBoxButton.OK, MessageBoxImage.Error); return; } else { string BackUpLocation = txtPath.Text.Trim(); string DatabaseName = CboDb.SelectedValue.ToString().Trim(); string BackUpFileName = CboDb.SelectedValue.ToString().Trim() + dtpNgay.SelectedDate.Value.ToString("ddMMyyyy") + ".bak"; BackupDatabase(BackUpLocation, BackUpFileName, DatabaseName); } } catch (Exception ex) { MessageBox.Show(ex.Message); } cls.DongKetNoi(); }
//end //---------------------------------------------------------------- public void BackUpDb(string fileName, string filePath) { string sqlBackup = "BACKUP DATABASE [" + fileName + "] TO DISK='" + filePath + "'"; ClsConnectLocal cnn = new ClsConnectLocal(); cnn.ClsConnect(); cnn.UpdateDataText(sqlBackup); cnn.DongKetNoi(); }
public void RestoreDb(string fileName, string filePath) { string sqlRestore = "Use master Restore Database [" + fileName + "] from DISK='" + filePath + "'"; string drop = "drop database " + fileName; ClsConnectLocal cnn = new ClsConnectLocal(); cnn.ClsConnect(); cnn.UpdateDataText(drop); cnn.UpdateDataText(sqlRestore); cnn.DongKetNoi(); }