c#动态备分数据库方法

最新推荐文章于 2024-08-23 23:20:17 发布

yubo35033720

最新推荐文章于 2024-08-23 23:20:17 发布

阅读量494

点赞数

分类专栏： c#编程系列文章标签：数据库 c# sqlserver string exception database

本文链接：https://blog.csdn.net/yubo35033720/article/details/1568936

版权

c#编程系列专栏收录该内容

16 篇文章 0 订阅

订阅专栏

protected void Button1_Click(object sender, EventArgs e)
    {
        string bakname="twohand";
        SqlConnection myConnection = new SqlConnection();
        string strconn = ConfigurationSettings.AppSettings["sqlserver"];

        myConnection.ConnectionString = strconn;

        string sql = "backup database towhand to disk = '" + Server.MapPath("").ToString() + "//" + bakname+ ".bak'";
        try
        {
    SqlCommand cmd = new SqlCommand(sql, myConnection);
    myConnection.Open();

    cmd.ExecuteNonQuery();
    myConnection.Close();
    bacname = bakname + ".bak'";
    string filename = Server.MapPath("").ToString() + "//" + bacname;

Response.Clear();

Response.ContentType = "application/octet-stream";

Response.AddHeader("Content-Disposition", "attachment;FileName=" + HttpUtility.UrlEncode(filename, System.Text.Encoding.UTF8));

Response.WriteFile(filename);

     Response.End();

    }
    catch(Exception ex)
    {
     Response.Write("<script language=javascript>alert('备份失败！');</script>");

}
}