备份数据库

        /// <summary>
        /// 备份数据库
        /// </summary>
        public void BackInfo()
        {
            try
            {
                this.saveFileDialog1.InitialDirectory = Application.StartupPath + "//";//默认路径为D：//
                saveFileDialog1.Filter = "备份文件 (*.bak)|*.bak|所有文件 (*.*)|*.*";//筛选器，定义文件类型
                saveFileDialog1.FilterIndex = 1;        //默认值为第一个
                saveFileDialog1.RestoreDirectory = true;      //重新定位保存路径
                if (saveFileDialog1.ShowDialog() == DialogResult.OK)
                {
                    if (!File.Exists(saveFileDialog1.FileName.ToString()))
                    {
                        SqlConnection con = new SqlConnection();  //利用代码实现连接数据库
                        con.ConnectionString = "server=.;uid=sa;pwd=;database=db_showHouse";
                        con.Open();
                        SqlCommand com = new SqlCommand();
                        this.textBox1.Text = saveFileDialog1.FileName.ToString();
                        com.CommandText = "BACKUP DATABASE db_showHouse TO DISK = '" + saveFileDialog1.FileName.ToString() + "'";
                        com.Connection = con;       //连接
                        com.ExecuteNonQuery();          //执行
                        con.Close();
                        con.Close();
                        con = null;
                        MessageBox.Show("数据备份成功！");
                    }
                    else
                    {
                        MessageBox.Show("请重新命名！");
                    }
                }
            }
            catch (Exception k)
            {
                MessageBox.Show(k.Message);
                return;
            }
        }