当前位置: 代码迷 >> C# >> C#winform 数据备份/复原
  详细解决方案

C#winform 数据备份/复原

热度:322   发布时间:2016-05-05 04:01:09.0
C#winform 数据备份/还原

两个查找已经编好
 private void button3_Click(object sender, EventArgs e)
        {
           
            this.folderBrowserDialog1.ShowNewFolderButton = true;
            this.folderBrowserDialog1.ShowDialog();
            this.textBox2.Text = this.folderBrowserDialog1.SelectedPath;
        }

        private void button4_Click(object sender, EventArgs e)
        {
            this.folderBrowserDialog1.ShowNewFolderButton = true;
            this.folderBrowserDialog1.ShowDialog();
            this.textBox2.Text = this.folderBrowserDialog1.SelectedPath;
        }
但是备份还是有问题
 private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection("server=.;database=小区物业;uid=sky;pwd=");
            string Str_dar = "";
            if (radioButton1.Checked == true)
            {
                Str_dar = System.Environment.CurrentDirectory + "C:\Users\sty\Documents\Visual Studio 2008\Projects\WindowsFormsApplication1\bar";
            }
            if (radioButton2.Checked == true)
            {
                Str_dar = textBox2.Text + "\\";
            }
            if (textBox2.Text == "" & radioButton2.Checked == true)
            {
                MessageBox.Show("请选择备份数据库文件的路径");
                return;
            }
           try
            {
                string path = this.folderBrowserDialog1.SelectedPath;
                    string sql = string.Format("Backup database 小区物业 to disk = textBox2.Text"); 
                    SqlConnection coon = new SqlConnection("server=.;database=小区物业;uid=sky;pwd=");
                    coon.Open();
                    SqlCommand command = new SqlCommand(sql, coon);
                   command.ExecuteNonQuery();
                MessageBox.Show("数据备份成功", "提示",MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
            }
           catch (Exception err)
           {
               MessageBox.Show(err.Message);
           }
        }
大神们求教
------解决思路----------------------
string sql = string.Format("Backup database 小区物业 to disk = textBox2.Text"); 
string sql = string.Format("Backup database 小区物业 to disk = " + textBox2.Text);
 


------解决思路----------------------
string sql = string.Format("Backup database 小区物业 to disk = '" + textBox2.Text +"'");
 
  相关解决方案