ASP.NET下备份与还原数据库代码

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了ASP.NET下备份与还原数据库代码，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含4753字，纯文字阅读大概需要7分钟。

内容图文

核心技术：
代码如下:

using System.Data.SqlClient; 
using System.IO; 
string SqlStr1 = "Server=(local);DataBase=master;Uid=sa;Pwd="; 
string SqlStr2 = "Exec sp_helpdb"; 
string SqlStr1 = "Server=(local);database='" + this.DropDownList1.SelectedValue + "';Uid=sa;Pwd="; 
string SqlStr2 = "backup database " + this.DropDownList1.SelectedValue + " to disk='" + this.TextBox1.Text.Trim() + ".bak'"; 
 
1.前台 
 代码如下:

<table> 
<tr> 
<td style="width: 100px"><span style="font-size: 9pt">操 作 数 据 库</span></td> 
<td><asp:DropDownList ID="DropDownList1" runat="server" Font-Size="9pt" Width="124px"></asp:DropDownList></td> 
<td style="width: 100px"></td> 
</tr> 
<tr> 
<td style="width: 100px"><span style="font-size: 9pt">备份名称和位置</span></td> 
<td style="width: 100px"><asp:TextBox ID="TextBox1" runat="server" Font-Size="9pt" Width="117px"></asp:TextBox></td> 
<td style="width: 100px"><span style="font-size: 9pt; color: #ff3300">（如D:\beifen）</span></td> 
</tr> 
<tr> 
<td colspan="3"><asp:Button ID="Button1" runat="server" Font-Size="9pt" OnClick="Button1_Click" Text="备份数据库" /></td> 
</tr> 
</table> 
 
2.后台 
 代码如下:

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) 
{ 
string SqlStr1 = "Server=(local);DataBase=master;Uid=sa;Pwd="; 
string SqlStr2 = "Exec sp_helpdb"; 
SqlConnection con = new SqlConnection(SqlStr1); 
con.Open(); 
SqlCommand com = new SqlCommand(SqlStr2, con); 
SqlDataReader dr = com.ExecuteReader(); 
this.DropDownList1.DataSource = dr; 
this.DropDownList1.DataTextField = "name"; 
this.DropDownList1.DataBind(); 
dr.Close(); 
con.Close(); 
} 
} 
protected void Button1_Click(object sender, EventArgs e) 
{ 
string SqlStr1 = "Server=(local);database='" + this.DropDownList1.SelectedValue + "';Uid=sa;Pwd="; 
string SqlStr2 = "backup database " + this.DropDownList1.SelectedValue + " to disk='" + this.TextBox1.Text.Trim() + ".bak'"; 
SqlConnection con = new SqlConnection(SqlStr1); 
con.Open(); 
try 
{ 
if (File.Exists(this.TextBox1.Text.Trim())) 
{ 
Response.Write("<script language=javascript>alert('此文件已存在，请从新输入！');location='Default.aspx'</script>"); 
return; 
} 
SqlCommand com = new SqlCommand(SqlStr2, con); 
com.ExecuteNonQuery(); 
Response.Write("<script language=javascript>alert('备份数据成功！');location='Default.aspx'</script>"); 
} 
catch (Exception error) 
{ 
Response.Write(error.Message); 
Response.Write("<script language=javascript>alert('备份数据失败！')</script>"); 
} 
finally 
{ 
con.Close(); 
} 
} 
} 
 


还原SqlServer 
核心技术: 
 代码如下:

string SqlStr1 = "Server=(local);database='" + this.DropDownList1.SelectedValue + "';Uid=sa;Pwd="; 
string SqlStr2 = "use master restore database " + dbname + " from disk='" + path + "'"; 
 
1.前台 
 代码如下:

<table> 
<tr> 
<td style="width: 100px; height: 21px"><span style="font-size: 9pt">操 作 数 据 库</span></td> 
<td><asp:DropDownList ID="DropDownList1" runat="server" Font-Size="9pt" Width="124px"></asp:DropDownList></td> 
<td style="width: 100px; height: 21px"></td> 
</tr> 
<tr> 
<td style="width: 100px"><span style="font-size: 9pt">操 作 数 据 库</span></td> 
<td style="width: 100px"><asp:FileUpload ID="FileUpload1" runat="server" Font-Size="9pt" Width="190px" /></td> 
<td style="width: 100px"> 
</td> 
</tr> 
<tr> 
<td colspan="3"><asp:Button ID="Button1" runat="server" Font-Size="9pt" OnClick="Button1_Click" Text="还原数据库" /></td> 
</tr> 
</table> 
 
2.后台 
 代码如下:

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) 
{ 
string SqlStr1 = "Server=(local);DataBase=master;Uid=sa;Pwd="; 
string SqlStr2 = "Exec sp_helpdb"; 
SqlConnection con = new SqlConnection(SqlStr1); 
con.Open(); 
SqlCommand com = new SqlCommand(SqlStr2, con); 
SqlDataReader dr = com.ExecuteReader(); 
this.DropDownList1.DataSource = dr; 
this.DropDownList1.DataTextField = "name"; 
this.DropDownList1.DataBind(); 
dr.Close(); 
con.Close(); 
} 
} 

protected void Button1_Click(object sender, EventArgs e) 
{ 
string path = this.FileUpload1.PostedFile.FileName; //获得备份路径及数据库名称 
string dbname = this.DropDownList1.SelectedValue; 
string SqlStr1 = "Server=(local);database='" + this.DropDownList1.SelectedValue + "';Uid=sa;Pwd="; 
string SqlStr2 = "use master restore database " + dbname + " from disk='" + path + "'"; 
SqlConnection con = new SqlConnection(SqlStr1); 
con.Open(); 
try 
{ 
SqlCommand com = new SqlCommand(SqlStr2, con); 
com.ExecuteNonQuery(); 
Response.Write("<script language=javascript>alert('还原数据成功！');location='Default.aspx'</script>"); 
} 
catch (Exception error) 
{ 
Response.Write(error.Message); 
Response.Write("<script language=javascript>alert('还原数据失败！')</script>"); 
} 
finally 
{ 
con.Close(); 
} 
} 
} 

            
            


           
                
                                                

内容总结

以上是互联网集市为您收集整理的ASP.NET下备份与还原数据库代码全部内容，希望文章能够帮你解决ASP.NET下备份与还原数据库代码所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---