62,041
社区成员
发帖
与我相关
我的任务
分享
#region 创建备份
protected void LinkButton1_Click(object sender, EventArgs e)
{
//创建文件夹
string VMdata = "DB";
string address = Server.MapPath("~\\Data\\");
DirectoryInfo dir = new DirectoryInfo(VMdata);
if (!dir.Exists == false)
{
ui.Alert(this, "此数据库不存在");
}
else
{
//判断文件夹是否存在
if (!System.IO.Directory.Exists(address))
{
//创建文件夹
System.IO.Directory.CreateDirectory(address);
}
else
{
//调用备份数据库的方法
BackUpDB1(address);
ui.Alert(this, "数据库备份成功");
//重新绑定
CreateTable();
}
}
}
#endregion
#region 备份数据库(本地备份)
public string BackUpDB1(string backAddress)
{
try
{
StringBuilder sql = new StringBuilder();
string DataName = "DB" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".bak";
//备份后的文件名称为原数据库名称+时分秒
sql.Append("backup database DB to disk='" + backAddress + DataName + "'");
db.ExecuteReader(sql.ToString());
return DataName;
}
catch (Exception)
{
throw;
}
}
#endregion