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是一个下拉列表控件,用于选择要备份的数据库,但是不能成功,老是提示错误说有语法错误(红色字体那)
{
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是一个下拉列表控件,用于选择要备份的数据库,但是不能成功,老是提示错误说有语法错误(红色字体那)
加空格
引号不对还是少了加号
//....
SqlCommand com = new SqlCommand(cmdtxt2, con);
"backup database " + this.DDLDataBase.SelectedValue + " to disk='"+this.TextBox1.Text.Trim()+".bak'";