Backup and Restore database code under ASP. NET

Core technologies:
Copy codeThe Code is as follows: 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. Front-end Copy codeThe Code is as follows: <table>
<Tr>
<Td style = "width: 100px"> <span style = "font-size: 9pt"> operational data warehouse </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"> Backup name and location </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"> (for example, D: \ beifen) </span> </td>
</Tr>
<Tr>
<Td colspan = "3"> <asp: button ID = "Button1" runat = "server" Font-Size = "9pt" OnClick = "button#click" Text = "backup database"/> </td>
</Tr>
</Table>

2. Background Copy codeThe Code is as follows: 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 button#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 ('this file already exists. Please input it again! '); Location = 'default. aspx' </script> ");
Return;
}
SqlCommand com = new SqlCommand (SqlStr2, con );
Com. ExecuteNonQuery ();
Response. Write ("<script language = javascript> alert ('data backed up successful! '); Location = 'default. aspx' </script> ");
}
Catch (Exception error)
{
Response. Write (error. Message );
Response. Write ("<script language = javascript> alert ('data backup failed! ') </Script> ");
}
Finally
{
Con. Close ();
}
}
}

Restore SqlServer
Core technologies:
Copy codeThe Code is as follows: string SqlStr1 = "Server = (local); database = '" + this. DropDownList1.SelectedValue + "'; Uid = sa; Pwd = ";
String SqlStr2 = "use master restore database" + dbname + "from disk = '" + path + "'";

1. Front-endCopy codeThe Code is as follows: <table>
<Tr>
<Td style = "width: 100px; height: 21px"> <span style = "font-size: 9pt"> operational data warehouse </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"> operational data warehouse </span> </td>
<Td style = "width: 100px"> <asp: fileUpload ID = "FileUpload1" runat = "server" Font-Size = "9pt" Width = "pixel PX"/> </td>
<Td style = "width: 100px">
</Td>
</Tr>
<Tr>
<Td colspan = "3"> <asp: button ID = "Button1" runat = "server" Font-Size = "9pt" OnClick = "button#click" Text = "Restore database"/> </td>
</Tr>
</Table>

2. Background Copy codeThe Code is as follows: 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 button#click (object sender, EventArgs e)
{
String path = this. FileUpload1.PostedFile. FileName; // obtain the backup path and database name.
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 ('data restored successfully! '); Location = 'default. aspx' </script> ");
}
Catch (Exception error)
{
Response. Write (error. Message );
Response. Write ("<script language = javascript> alert ('data restoration failed! ') </Script> ");
}
Finally
{
Con. Close ();
}
}
}