Asp. NET Backup RESTORE Database

Core technology:
Using System.Data.SqlClient;
Using System.IO;
String SqlStr1 = "server= (local);D atabase=master; Uid=sa; Pwd= ";
String SqlStr2 = "Exec sp_helpdb";
String SqlStr1 = "server= (local);d atabase= '" + this. Dropdownlist1.selectedvalue + "'; Uid=sa; Pwd= ";
String SqlStr2 = "BACKUP Database" + this. Dropdownlist1.selectedvalue + "to disk= '" + this. TextBox1.Text.Trim () + ". Bak '";

1. Front Desk

<table>
<tr>
<TD style= "width:100px" ><span style= "font-size:9pt" > Operations Database </span></td>
<td><asp:dropdownlist id= "DropDownList1" runat= "Server" font-size= "9pt" width= "124px" ></asp:d Ropdownlist></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 "> (e.g. D:/beifen) </span></td>
</tr>
<tr>
<TD colspan= "3" ><asp:button id= "Button1" runat= "Server" font-size= "9pt" onclick= "Button1_Click" text= "Backup Database "/></td>
</tr>
</table>

2. Backstage

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);D atabase=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);d atabase= '" + 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 enter it from new. '); location= ' default.aspx ' </script> ');
Return
}
SqlCommand com = new SqlCommand (SqlStr2, con);
Com. ExecuteNonQuery ();
Response.Write (' <script language=javascript>alert (' backup data was successful. '); location= ' default.aspx ' </script> ');
}
catch (Exception error)
{
Response.Write (Error. message);
Response.Write (' <script Language=javascript>alert (') failed to backup data. ') </script> ");
}
Finally
{
Con. Close ();
}
}
}

Restore SQL Server
Core technology:
String SqlStr1 = "server= (local);d atabase= '" + this. Dropdownlist1.selectedvalue + "'; Uid=sa; Pwd= ";
String SqlStr2 = "Use master Restore Database" + dbname + "from disk= '" + Path + "'";

1. Front Desk
<table>
<tr>
<TD style= "width:100px; height:21px "><span style=" font-size:9pt > Operations Database </span></td>
<td><asp:dropdownlist id= "DropDownList1" runat= "Server" font-size= "9pt" width= "124px" ></asp:d Ropdownlist></td>
<TD style= "width:100px; height:21px "></td>
</tr>
<tr>
<TD style= "width:100px" ><span style= "font-size:9pt" > Operations Database </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= "RESTORE Database" "/></td>
</tr>
</table>
2. Backstage

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);D atabase=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; Get backup path and database name
String dbname = this. Dropdownlist1.selectedvalue;
String SqlStr1 = "server= (local);d atabase= '" + 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 (') succeeded in restoring data. '); location= ' default.aspx ' </script> ');
}
catch (Exception error)
{
Response.Write (Error. message);
Response.Write (' <script Language=javascript>alert (') failed to restore data. ') </script> ");
}
Finally
{
Con. Close ();