Question

如何用C#编写 实现数据备份和还原

不好意思。。因为有些东西，还是没弄懂。希望您能帮忙解决。 我的界面和控件与您的有些冲突。希望您能把您做的界面和文件发给我下 希望您能帮人帮到底，呵呵，无限感激

Answer 1

----------------------------------------数据备份页面-----------------------------<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="DataBank.aspx.cs" Inherits="DataProcessing_DataBank" Title="数据库备份" %><asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<%--备份--%>
<div>
<div>
<div>
<div>
<h2> 数据库备份 </h2>
</div>
<div>

<div style="width: 100%">
<div style="padding-left: 5px; margin-left: -1px" mce_style="padding-left: 5px; margin-left: -1px">
请输入备份文件名： web工程\Backup\<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label><asp:TextBox ID="pathTextBox" runat="server" Width="122px">JJGoodShopDB</asp:TextBox> .bak
</div>
</div>
<div >
<asp:Button ID="backupButton" Text="备份数据库" runat="server" OnClick="backupButton_Click" />
</div>
<div style="width: 100%">
<div style="width: 400px">

</div>
<div style="margin-left: 1px" mce_style="margin-left: 1px">
<asp:Label ID="infoLabel" runat="server" ForeColor="red"></asp:Label></div>
</div>
</div>
</div>
</div>
</div>
</asp:Content>---------------------------------------------数据备份逻辑处理----------------------------------------------------using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.IO;public partial class DataProcessing_DataBank : System.Web.UI.Page
{
//数据库连接字符串
protected void Page_Load(object sender, EventArgs e)
{ if (!IsPostBack)
{
Label1.Text = DateTime.Now.ToString("yyyy年MM月dd日HH时mm分ss秒");
}
} ///＜summary＞
/// 数据库备份
/// 参数信息要备份的数据库的名称Backup .Database = "Northwind";
/// 另外一个是存放备份文件的路径和文件名称Backup .Files = @"c:\databak.bak";
///＜/summary＞
protected void backupButton_Click(object sender, EventArgs e)
{
SQLDMO.Backup Backup = new SQLDMO.BackupClass(); SQLDMO.SQLServer SQLServer = new SQLDMO.SQLServerClass();
string pathname =Label1.Text+pathTextBox.Text.Trim().ToString();
try
{
SQLServer.LoginSecure = false;
SQLServer.Connect(@".\SQLEXPRESS", "sa", "123");
Backup .Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
Backup.Database = "JJGoodShopDB";
//要备份的数据库的名称，例如Northwind
Backup.Files =Server.MapPath( @"~\Backup\"+pathname+".bak");
//存放路径，和备份文件的名称
Backup.BackupSetName = "JJGoodShopDB";
Backup .BackupSetDescription = "数据库备份";
Backup .Initialize = true;
Backup .SQLBackup(SQLServer);
backupButton.Enabled = false;
infoLabel.Text = "数据库备份成功！！<br>文件成功保存在了" + Backup.Files;
}catch(Exception eee)
{
infoLabel.Text = "数据库备份失败！！<br>"+eee.Message;
//throw eee;
}
finally
{
SQLServer.DisConnect();
}

}
}

Answer 2

呵呵，你怎么没有回楼上的那个人呢？