----------------------------------------æ°æ®å¤ä»½é¡µé¢-----------------------------<%@ 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();
}
}
}
温馨提示:答案为网友推荐,仅供参考