数据库备份与还原c#.net实现
原文发布时间为:2008-10-25 —— 来源于本人的百度文章 [由搬家工具导入]
数据库备份与还原c#.net实现:
页面上面有 备份,还原,下拉菜单(浏览备份文件夹下面的所有文件名),删除(删除备份),这四个控件。。。。。备份的时候把 时间转化成字符串格式 然后作为文件名保存 防止重复。
前台代码:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="备份" /><br />
<br />
<br />
<asp:DropDownList ID="DropDownList1" runat="server">
</asp:DropDownList><br />
<br />
<asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="还原" />
<asp:Button ID="Button3" runat="server" OnClick="Button3_Click" Text="删除" /></div>
</form>
</body>
</html>
后台代码:
using System;
using System.Data;
using System.Configuration;
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 _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindFileName();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string sql = "Backup Database pubs to DISK='" + Server.MapPath("App_Data//BackUp//pubs" + DateTime.Now.ToString("yyyyMMddhhmmss")) + "'";
SqlConnection pubsConn = new SqlConnection("Server=.\\SQLEXPRESS;Database=pubs;Integrated Security=True");
SqlCommand cmd = new SqlCommand(sql, pubsConn);
pubsConn.Open();
int a=cmd.ExecuteNonQuery();
if (a == -1)
{
Response.Write("success!");
}
else
{
Response.Write("fail!");
}
pubsConn.Close();
BindFileName();
}
public void BindFileName()
{
DropDownList1.Items.Clear();
string path = Server.MapPath("App_Data//BackUp");
DirectoryInfo di = new DirectoryInfo(path);
foreach (FileInfo fi in di.GetFiles())
{
ListItem li=new ListItem();
li.Value=fi.FullName;
li.Text=fi.Name;
DropDownList1.Items.Add(li);
}
}
protected void Button2_Click(object sender, EventArgs e)
{
string sql = "Restore Database pubs From DISK='" + DropDownList1.SelectedValue + "'";
SqlConnection masConn = new SqlConnection("Server=.\\SQLEXPRESS;Database=master;Integrated Security=True");
SqlCommand cmd = new SqlCommand(sql, masConn);
masConn.Open();
int a=cmd.ExecuteNonQuery();
if (a == -1)
{
Response.Write("success!");
}
else
{
Response.Write("fail!");
}
masConn.Close();
}
protected void Button3_Click(object sender, EventArgs e)
{
File.Delete(DropDownList1.SelectedValue);
BindFileName();
}
}
最新文章
- [译]理解Javascript的异步等待
- [LeetCode] Mini Parser 迷你解析器
- Redis集群搭建1
- AutoVue ISDK学习总结(一)
- php开发(TP框架使用)
- 初探Team Foundation Server (TFS) 2015 REST API
- Gt9xx芯片,在规格书+Linux驱动的基础上,移植为USB裸机经验。直接用开发板,不去碰硬件的坑。
- C#实现Combobox自动匹配字符
- Socket 之 同步以及异步通信
- iOS小技巧 - 和屏幕等宽的Table分割线
- SVN的版本日期
- Java中读取某个目录下的所有文件和文件夹
- HDU 1009 FatMouse&#39; Trade(贪心)
- Raid 配置
- linux常用命令 cut字符截取命令
- Android Studio 之 注释模板
- shiro 密码的MD5盐值加密
- java后台技术
- CSDN博客QQ加群、微信
- 正向代理到指定泛域名的nginx配置