restore.aspx.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Web.Security;
using DbPrvd;

public partial class restore : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["User"] == null || Session["Role"] == null)
            Response.Write("<script type='text/javascript'>parent.document.location='timeout.htm';</script>");
        if (Session["Role"].ToString() != "管理员")
        {
            Response.Write("<script type='text/javascript'>alert('您无权操作');history.go(-1);</script>");
        }
    }
    protected void Button1_Click1(object sender, EventArgs e)
    {

        string path = this.FileUpload1.PostedFile.FileName; //获得备份路径及数据库名称
        string restoreQuery = "use master restore database mall from disk='" + path + "'";
        string connstr = SqlHelper.ConStr;
        SqlConnection con = new SqlConnection(connstr);
        con.Open();
        try
        {
            SqlCommand com = new SqlCommand();
            com.Connection = con;
            //com.CommandType = CommandType.StoredProcedure;
            //com.CommandText = "killspid";
            //com.ExecuteNonQuery();
            com.CommandType = CommandType.Text;
            com.CommandText = restoreQuery;
            Response.Write("<script type='text/javascript'>alert('操作成功');</script>");
        }
        catch (Exception error)
        {
            Response.Write(error.Message);
            Response.Write("<script language=javascript>alert('备份数据失败！')</script>");
        }
    }
}