C# 数据库备份问题??
#region 备份
private void BeiFen()
{
try
{
string strg = Application.StartupPath.ToString();
strg = strg.Substring(0, strg.LastIndexOf("\\"));
strg = strg.Substring(0, strg.LastIndexOf("\\"));
strg += @"\Data";
string backSQL = @"BACKUP?DATABASE?jxc?TO?Disk='" + strg + "\\" + "" + ".bak" + "'";
DbHelperSQL.ExecuteSql(backSQL);
if (MessageBox.Show("备份成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation) == DialogResult.OK)
{
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
#endregion
备份时报错语法问题?错误是《‘’》
[解决办法]
看backSQL的语法没有问题.
请问LZ程序所连的数据库是SQL Server吗?
把此句SQL单独放在SSMS里执行是否正常?
[解决办法]
在C#中执行路径的话要用@前缀,你再试试看