濡備綍鐢–#缂栧啓 瀹炵幇鏁版嵁澶囦唤鍜岃繕鍘?- 宸茶В鍐?- 鎼滄悳闂棶

 
鎴戞鍦ㄥ仛鐗╀笟绠＄悊绯荤粺涓殑 鈥滅郴缁熺鐞嗏€?妯″潡锛岄渶瑕佸疄鐜版暟鎹簱鐨勫浠藉拰杩樺師銆?/p>
璇烽棶锛氬湪Microsoft visual studio涓紝鐢–#璇█缂栧啓锛屽浣曢€氳繃鈥滄祻 瑙堚€濇寜閽紝浠庣數鑴戜腑鎻愬彇URL鍐欏叆鏂囨湰妗嗭紝鐒跺悗閫氳繃鈥滃浠解€濆拰鈥滆繕鍘熲€濆疄鐜扮浉搴旂殑 澶囦唤鏁版嵁搴撳拰杩樺師鏁版嵁搴?鍔熻兘銆傜揣鎬ワ紒

答案：///锛渟ummary锛?br>/// 鏁版嵁搴撳浠?br>/// 鍙傛暟淇℃伅瑕佸浠界殑鏁版嵁搴撶殑鍚嶇О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";
//瑕佸浠界殑鏁版嵁搴撶殑鍚嶇О锛屼緥濡侼orthwind 
Backup.Files =Server.MapPath( @"~\Backup\"+pathname+".bak"); 
//瀛樻斁璺緞锛屽拰澶囦唤鏂囦欢鐨勫悕绉?
Backup.BackupSetName = "JJGoodShopDB";
Backup .BackupSetDescription = "鏁版嵁搴撳浠?quot;;
Backup .Initialize = true; 
Backup .SQLBackup(SQLServer);
backupButton.Enabled = false;
infoLabel.Text = "鏁版嵁搴撳浠芥垚鍔燂紒锛?lt;br>鏂囦欢鎴愬姛淇濆瓨鍦ㄤ簡" + Backup.Files;
}catch(Exception eee) 
{
infoLabel.Text = "鏁版嵁搴撳浠藉け璐ワ紒锛?lt;br>"+eee.Message;
//throw eee;
} 
finally 
{
SQLServer.DisConnect(); 
}

}
}
瑕佸叏鐨勮繕鏈夛紝
 
 
 
 
//杩樺師SqlServer鏁版嵁搴?
string path = this.FileUpload1.PostedFile.FileName; //鑾峰緱澶囦唤璺緞鍙婃暟鎹簱鍚嶇О 
string SqlStr1 = System.Web.Configuration
.WebConfigurationManager
.ConnectionStrings["JJGoodShopDBConnectionString"]
.ConnectionString;
string SqlStr2 = "use master restore database JJGoodShopDB from disk='" + path + "'";
SqlConnection con = new SqlConnection(SqlStr1);
con.Open();
try
{
SqlCommand com = new SqlCommand(SqlStr2, con);
com.ExecuteNonQuery();
Label1.Text = "杩樺師鏁版嵁鎴愬姛锛?quot;;
Button1.Enabled = false;
}
catch (Exception error)
{
Label1.Text = "杩樺師鏁版嵁澶辫触锛?lt;br>" + error.Message ;
}
finally
{
con.Close();
}
//杩欐槸杩樺師鏁版嵁搴?/p>

上一个：如何用c#实现获取本机网卡信息
下一个：关于asp.net 2.0 C# 变量的解释