private void btnRestore_Click(object sender, EventArgs e) { string queryString = "use [master]\r\n select * from sysprocesses where dbid=DB_ID('dd')\r\n "; InlineQuery query = DB.Query(); IDataReader SidList = query.ExecuteReader(queryString); while (SidList.Read()) { try { queryString = "kill " + SidList["spid"].ToString(); query.Execute(queryString); } catch { } } try { queryString = "use [master]\r\n RESTORE DATABASE DD FROM disk='" + this.tbxRestoreFile.Text + "'"; query.Execute(queryString); MessageBox.Show("恢复成功", "提示信息"); } catch { MessageBox.Show("恢复失败", "提示信息"); } }
private void btnBackup_Click(object sender, EventArgs e) { try { string queryString = "Backup database DD to disk='" + this.tbxBackupFile.Text + "'"; InlineQuery query = DB.Query(); query.Execute(queryString); MessageBox.Show("备份成功", "提示信息"); } catch { MessageBox.Show("备份失败", "提示信息"); } }