CFSDN坚持开源创造价值，我们致力于搭建一个资源共享平台，让每一个IT人在这里找到属于你的精彩世界.

这篇CFSDN的博客文章ASP.NET下备份与还原数据库代码由作者收集整理，如果你对这篇文章有兴趣，记得点赞哟.

核心技术：  。

复制代码代码如下

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下备份与还原数据库代码的内容请搜索CFSDN的文章或继续浏览相关文章，希望大家以后支持我的博客！ 。