예제 #1
0
        private void button2_Click(object sender, System.EventArgs e)
        {
            if (textBox_openFile.Text == "")
            {
                MessageBox.Show("必须输入争取文件名!", "警告!",
                                MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                return;
            }

            string       str_Sql, errorstring = "";
            DialogResult result = MessageBox.Show(this, "真的要恢复吗?", "提醒!", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);

            if (result == DialogResult.OK)
            {
                //必须用特殊的到Master数据库的连接,断开所有SchoolManage的向外联系,才能恢复
                str_Sql = "restore database " + ConfigurationSettings.AppSettings["Database"]
                          + " from disk='" + textBox_openFile.Text + "' with replace";
                errorstring = conn.DBRestore(str_Sql);
                if (errorstring != "OK")
                {
                    MessageBox.Show("恢复失败!请检查数据库!" + errorstring, "提醒!",
                                    MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    button1.Enabled = false;
                    return;
                }
                MessageBox.Show("恢复成功!" + errorstring, "提醒!",
                                MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            }
            else
            {
                return;
            }
        }