datahy.aspx.cs

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.IO;



public partial class datahy : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string path = "C:\netxxcssfxtshfw.dat"; //获得备份路径及数据库名称
        string dbname = "netxxcssfxtshfwbak";
        string SqlStr1 = "Server=(local);database='netxxcssfxtshfw';Uid=sa;Pwd=";
        string SqlStr2 = "use master restore database " + dbname + " from disk='" + path + "'";
        SqlConnection con = new SqlConnection(SqlStr1);
        con.Open();
        try
        {
            SqlCommand com = new SqlCommand(SqlStr2, con);
           // com.ExecuteNonQuery();
            Response.Write("<script language=javascript>alert('还原数据成功！');location='sy.aspx'</script>");
        }
        catch (Exception error)
        {
            Response.Write(error.Message);
            Response.Write("<script language=javascript>alert('还原数据失败！')</script>");
        }
        finally
        {
            con.Close();
        }
    }
}