Question

有关C#备份错误问题

if (textBox1.Text == "" || textBox2.Text =="")
{
MessageBox.Show("输入不完整，请检查输入！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
string connString = @"Data Source=.\SQLEXPRESS;Initial Catalog=AAA;Integrated Security=True";
SqlConnection connection = new SqlConnection(connString);
try
{
connection.Open();
string sql = @"backup database " + textBox1.Text + " TO disk='" + textBox2.Text + "'";
SqlCommand command = new SqlCommand(sql,connection );
int count = command.ExecuteNonQuery ();
if (count > 0)
{
MessageBox.Show("备份成功！", "成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("备份失败！", "失败", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message , "信息提示", MessageBoxButtons.OK,MessageBoxIcon.Error);
}
finally
{
connection.Close();
}

一直不能成功，问题在哪里，怎么改？

Answer 1

textBox2.Text中不要输入"D:\"
换一个带文件名的,如:"D:\db.bak"
这样试试.

Answer 2

jzxhcmn