Пример #1
0
        private void ok_Click(object sender, EventArgs e)//还原数据库
        {
            this.UseOtherDatabase();
            /////////////////////////////////
            SqlConnection connect = new SqlConnection("Server=" + InitConnect.GetServer() + ";Database=master;User ID=" + InitConnect.GetUser() + ";Password="******"restore database " + InitConnect.GetDatabaseName() + " from disk='" + this.filename.Text.Trim() + "' with replace", connect);
                cmd.ExecuteNonQuery();
                MessageBox.Show("成功还原数据库\"" + InitConnect.GetDatabaseName() + "\"!", "恭喜", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
                this.Close();
            }
            catch (Exception ee)
            {
                MessageBox.Show("还原数据库\"" + InitConnect.GetDatabaseName() + "\"失败!\n错误信息:" + ee.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
            }
            finally
            {
                connect.Close();
            }
        }