C # Backup and restore operations on the database, SQL statement implementation

///

Backup and restore operations on the database, SQL statement implementation

///

Implementing SQL statements for backup or recovery

Whether the operation is a backup operation, true or False

private void Bakreductsql (string cmdtext,bool isbak,string dbname)

{

String Constring=database.dbconnection.sqlnodbnameconnect ();

SqlConnection conn3 = new SqlConnection (constring);

SqlCommand Cmdbakrst = new SqlCommand ();

Try

{

if (conn3. state==connectionstate.closed)

Conn3. Open ();

Cmdbakrst.connection = CONN3;

Cmdbakrst.commandtype = CommandType.Text;

if (!isbak)//If the recovery operation

{

String setoffline = "Alter database" +dbname+ "Set Offline with rollback immediate";

String setonline = "Alter database" + dbname + "Set Online with Rollback immediate";

Cmdbakrst.commandtext = setoffline + Cmdtext + setonline;

}

Else

{

Cmdbakrst.commandtext = Cmdtext;

}

Cmdbakrst.executenonquery ();

if (!isbak)

{

MessageBox.Show ("The data is successfully restored to the state of the selected document!", "system messages");

}

Else

{

MessageBox.Show ("Congratulations, you have successfully backed up the current data!", "system Message");

}

}

catch (SqlException Sexc)

{

MessageBox.Show ("Failed, may be failed on database operation, Reason:" + sexc, "Database error message");

}

catch (Exception ex)

{

MessageBox.Show ("Sorry, operation failed, possible reason:" + ex, "system Message");

}

Finally

{

Cmdbakrst.dispose ();

Conn3. Close ();

}

}