No 127 · C#备份和还原数据库

来源：互联网发布：crontab java 编辑：程序博客网时间：2024/06/06 19:19

备份数据库

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.IO;namespace SMS.SysManage{    public partial class frmDataStore : Form    {        public frmDataStore()        {            InitializeComponent();        }        SMS.BaseClass.DataCon datacon = new SMS.BaseClass.DataCon();        private void btnSel_Click(object sender, EventArgs e)        {            fbDialogFile.ShowDialog();            txtDSPath.Text = fbDialogFile.SelectedPath.ToString().Trim()+"\\";        }        private void btnDStore_Click(object sender, EventArgs e)        {            try            {                if (File.Exists(txtDSPath.Text.Trim() + ".bak"))                {                    MessageBox.Show("该文件已经存在！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);                    txtDSPath.Text = "";                    txtDSPath.Focus();                }                else                {                    datacon.getcom("backup database db_SMS to disk='" + txtDSPath.Text.Trim() + ".bak'");                    MessageBox.Show("数据备份成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);                }            }            catch (Exception ex)            {                MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);            }        }        private void btnExit_Click(object sender, EventArgs e)        {            this.Close();        }        private void frmDataStore_FormClosed(object sender, FormClosedEventArgs e)        {            this.Close();        }    }}

#region  执行SqlCommand命令        /// <summary>        /// 执行SqlCommand        /// </summary>        /// <param name="M_str_sqlstr">SQL语句</param>        public void getcom(string M_str_sqlstr)        {            SqlConnection sqlcon = this.getcon();            sqlcon.Open();            SqlCommand sqlcom = new SqlCommand(M_str_sqlstr, sqlcon);            sqlcom.ExecuteNonQuery();            sqlcom.Dispose();            sqlcon.Close();            sqlcon.Dispose();        }        #endregion

还原数据库

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace SMS.SysManage{    public partial class frmDataRevert : Form    {        public frmDataRevert()        {            InitializeComponent();        }        SMS.BaseClass.DataCon datacon = new SMS.BaseClass.DataCon();        private void btnSel_Click(object sender, EventArgs e)        {            ofDialogFile.InitialDirectory = "D:\\";            ofDialogFile.Filter = "bak files (*.bak)|*.bak";            ofDialogFile.RestoreDirectory = true;            ofDialogFile.ShowDialog();            txtDRPath.Text = ofDialogFile.FileName.ToString().Trim();        }        private void btnDRevert_Click(object sender, EventArgs e)        {            try            {                datacon.getcom("use master restore database db_SMS from disk='" + txtDRPath.Text.Trim() + "'");                MessageBox.Show("数据还原成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);            }            catch (Exception ex)            {                MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);            }        }        private void btnExit_Click(object sender, EventArgs e)        {            this.Close();        }        private void frmDataRevert_FormClosed(object sender, FormClosedEventArgs e)        {            this.Close();        }    }}

#region  执行SqlCommand命令        /// <summary>        /// 执行SqlCommand        /// </summary>        /// <param name="M_str_sqlstr">SQL语句</param>        public void getcom(string M_str_sqlstr)        {            SqlConnection sqlcon = this.getcon();            sqlcon.Open();            SqlCommand sqlcom = new SqlCommand(M_str_sqlstr, sqlcon);            sqlcom.ExecuteNonQuery();            sqlcom.Dispose();            sqlcon.Close();            sqlcon.Dispose();        }        #endregion