protected void Backup_Click(object sender, EventArgs e)
    {
        string cmdtxt1 = "Server=(local);DataBase='" + this.DDLDataBase.SelectedValue + "';Integrated Security=SSPI;";
        string cmdtxt2 = "backup database" + this.DDLDataBase.SelectedValue + "to disk='"+this.TextBox1.Text.Trim()+".bak'";     
   SqlConnection con=new SqlConnection(cmdtxt1);
        con.Open();
        try
        {
            if (File.Exists(this.TextBox1.Text.Trim()))
            {
                Response.Write("<script language=javascript>alert('此文件已存在,请重新输入!');location='javascript:history.go(-1)';location='BackupD.aspx'</script>");
                return;
            }            SqlCommand com = new SqlCommand(cmdtxt2, con);
            com.ExecuteNonQuery();
            Response.Write("<script language=javascript>alert('备份数据库成功!');location='javascript:history.go(-1)';location='BackupD.aspx</script>");
        }
        catch (Exception ms)
        {
            Response.Write(ms.Message);
            Response.Write("<script language=javascript>alert('备份数据库失败!');location='javascript:history.go(-1)';location='BackupD.aspx</script>");
        }
        finally
        {
            con.Close();
            con.Dispose();
        }
    }
    
自己在做SQL的数据库备份操作,C#语言,以上是代码,DDLDataBase是一个下拉列表控件,用于选择要备份的数据库,但是不能成功,老是提示错误说有语法错误(红色字体那)

解决方案 »

  1.   

    string cmdtxt2 = "backup database " + this.DDLDataBase.SelectedValue + " to disk='"+this.TextBox1.Text.Trim()+".bak'"; 
    加空格
      

  2.   

    string cmdtxt2 = "backup database" + this.DDLDataBase.SelectedValue + "to disk='"+this.TextBox1.Text.Trim()+".bak'"; 
    引号不对还是少了加号
      

  3.   

    string cmdtxt2 = "backup database " + this.DDLDataBase.SelectedValue + " to disk='"+this.TextBox1.Text.Trim()+".bak'"; 
    //....
    SqlCommand com = new SqlCommand(cmdtxt2, con);
      

  4.   

    cmdtxt2 里面烧了空格了;  database 后和to  前面
     "backup database " + this.DDLDataBase.SelectedValue + " to disk='"+this.TextBox1.Text.Trim()+".bak'";