var Row = this.UltraWebGrid1.DisplayLayout.ActiveRow;
string brName = (string)Row.Cells.FromKey("Name").Value;
string filename = Server.MapPath("../");
string pathname = filename + @"backupAndRestore/" + brName;
string restore = "restore database sun from disk='" + pathname + "';";
SqlConnection con = new SqlConnection("Data Source=192.168.1.101;Initial Catalog=sun;Persist Security Info=True;User ID=sa;Password=123");
SqlCommand cmd = new SqlCommand(restore, con);
try
{
con.Open();
cmd.ExecuteNonQuery();
Response.Write("<script>alert('恢复成功! ');</script>");
}
catch
{
Response.Write("<script>alert('恢复失败! ');</script>");
}
finally
{
con.Close();
}