读书人

大神给看看这段数据库备份的代码老提

发布时间: 2012-08-22 09:50:34 作者: rapoo

大神给看看这段数据库备份的代码,老提示错误!
private void button1_Click(object sender, EventArgs e)
{
string backupname = textBox1.Text; //文件备份名称
string backup =@"BACKUP DATABASE [MaterialDataBase] TO DISK = N'"+textBox2.Text+"\\"+backupname+@".bak' WITH NOFORMAT, NOINIT, NAME = N'"+backupname+"', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GO";
MessageBox.Show(backup);
DataBase.operateSQL(backup); //执行SQL命令
MessageBox.Show("备份成功!");

}

private void button3_Click(object sender, EventArgs e)
{
FolderBrowserDialog path = new FolderBrowserDialog();
if (path.ShowDialog() == DialogResult.OK)
{
textBox2.Text = path.SelectedPath;
}
}


[解决办法]
设么错,如果是sql语句错误,就好好查查帮助,看看错误提示

读书人网 >C#

热点推荐