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

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

答案：----------------------------------------数据备份页面-----------------------------
<%@ 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(); 
        }
        
     }
}
呵呵，你怎么没有回楼上的那个人呢？

上一个：C#如何导出一个Excel表格多个sheet页
下一个：C#问题 各位大哥大姐们请帮帮忙啊！！！！！！