private void b_backup_Click(object sender, System.EventArgs e)
{
SqlConnection conn = new SqlConnection(strConn);
string nowpath=Request.PhysicalApplicationPath + "Exported//";
string sql=null;
if( conn.State == ConnectionState.Open)
conn.Close();
conn.ConnectionString = strConn;
conn.Open();
sql="backup database WTC to disk='"+nowpath+"//"+filename+"' with format,name='Full Backup of TradeDb/SQL'";
bool flag = false;
try
{
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
flag = true;
//MessageBox.Show("成功备份数据!备份记录为:"+nowpath+"//数据备份文件(不要删除).dll"," 成功了!", MessageBoxButtons.OK, MessageBoxIcon.Information );
}
catch(Exception)
{
flag = false;
//MessageBox.Show("出现错误,请与作者联系!"+err.ToString() ,"出错了!",MessageBoxButtons.OK ,MessageBoxIcon.Question );
}
finally
{
conn.Close();
}
//备份记录为:"+nowpath+"//数据备份文件(不要删除).dll
if(flag == true) //保存成功!
{
//Response.Write("<script language='JavaScript'>alert('成功备份数据!备份记录为:"+nowpath+"//数据备份文件(不要删除).dll');</script>");
//下載到客戶耑
WriteStream();
}
else //保存失败!
{
Response.Write("<script language='JavaScript'>alert('出现错误,请与作者联系!');</script>");
}
//
}