Admin/DataManager.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Admin_DataManager : System.Web.UI.Page
{
    SqlData data = new SqlData();
    protected void Page_Load(object sender, EventArgs e)
    {

        if (Session["Admin"] == null)
        {
            Alert.Alert1("登陆信息已失效，请重新登陆");
            Alert.Out();
        }
    }

    protected void btnBackUp_Click(object sender, EventArgs e)
    {
        string fileName = string.Format("WuYeGuanLi{0}.bak", DateTime.Now.ToString("yyyyMMdd"));
        string sql = string.Format("BACKUP DATABASE XiaoQuWuYe to DISK ='{0}{1}' with init", Server.MapPath("../DataBackUp/"), fileName);
        data.RunSql(sql);
        hlDown.Text = "备份成功,点击导出";
        hlDown.NavigateUrl = string.Format("../DataBackUp/{0}", fileName);
    }
}