//數據備份菜單點擊事件
?? private void mnuBackUp_Click(object sender, System.EventArgs e)
?? {
??? frmBackUp back=new frmBackUp(frmBackUp.SetType.BackUp);
??? back.Show();
??? //調用dll
??? BackUpAndReinstate.BackUp backup=new BackUpAndReinstate.BackUp(Application.StartupPath+"
\\BackUp\\TeachingBusiness.bak
");
??? string message=backup.DataBaseBackUp();
??? MessageBox.Show(message,"消息",MessageBoxButtons.OK,MessageBoxIcon.Information);
??? back.Close();
?? }
?? //數據恢復菜單點擊事件
?? private void mnuReinstate_Click(object sender, System.EventArgs e)
?? {
??? frmBackUp back=new frmBackUp(frmBackUp.SetType.Reinstate);
??? back.Show();
??? //調用dll
??? BackUpAndReinstate.Reinstate reinstate=new BackUpAndReinstate.Reinstate();
??? string message=reinstate.DataBaseReinstate();
??? MessageBox.Show(message,"消息",MessageBoxButtons.OK,MessageBoxIcon.Information);
??? back.Close();
?? }
?
frmBackUp窗體代碼:
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
namespace 教務系統
{
/// <summary>
/// frmBackUp 的摘要說明。
/// </summary>
public class frmBackUp : System.Windows.Forms.Form
{
?? private System.Windows.Forms.Label label1;
?? private System.Windows.Forms.PictureBox pictureBox1;
?? private System.Windows.Forms.Timer timer1;
?? private System.ComponentModel.IContainer components;
?? public enum SetType
?? {
??? BackUp,
??? Reinstate
?? }
?? private int type=0;
?? public frmBackUp(SetType settype)
?? {
??? //
??? // Windows 窗體設計器支持所必需的
??? //
??? InitializeComponent();
??? this.type=(int)settype;
??? //
??? //
?? }
?? /// <summary>
?? /// 清理所有正在使用的資源。
?? /// </summary>
?? protected override void Dispose( bool disposing )
?? {
??? if( disposing )
??? {
???? if(components != null)
???? {
????? components.Dispose();
???? }
??? }
??? base.Dispose( disposing );
?? }
?? #region Windows 窗體設計器生成的代碼
?? /// <summary>
?? /// 設計器支持所需的方法 - 不要使用代碼編輯器修改
?? /// 此方法的內容。
?? /// </summary>
?? private void InitializeComponent()
?? {
??? this.components = new System.ComponentModel.Container();
??? System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(frmBackUp));
??? this.label1 = new System.Windows.Forms.Label();
??? this.pictureBox1 = new System.Windows.Forms.PictureBox();
??? this.timer1 = new System.Windows.Forms.Timer(this.components);
??? this.SuspendLayout();
??? //
??? // label1
??? //
??? this.label1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
??? this.label1.Location = new System.Drawing.Point(8, 8);
??? this.label1.Name = "label1";
??? this.label1.Size = new System.Drawing.Size(256, 64);
??? this.label1.TabIndex = 0;
??? this.label1.Text = "正在備份數據,請稍侯......";
??? this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
??? //
??? // pictureBox1
??? //
??? this.pictureBox1.Image = ((System.Drawing.Image)(resources.GetObject("pictureBox1.Image")));
??? this.pictureBox1.Location = new System.Drawing.Point(24, 16);
??? this.pictureBox1.Name = "pictureBox1";
??? this.pictureBox1.Size = new System.Drawing.Size(64, 48);
??? this.pictureBox1.SizeMode = System.Windows.Forms.PictureBoxSizeMode.CenterImage;
??? this.pictureBox1.TabIndex = 1;
??? this.pictureBox1.TabStop = false;
??? //
??? // timer1
??? //
??? this.timer1.Interval = 300;
??? this.timer1.Tick += new System.EventHandler(this.timer1_Tick);
??? //
??? // frmBackUp
??? //
??? this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
??? this.ClientSize = new System.Drawing.Size(272, 80);
??? this.Controls.Add(this.pictureBox1);
??? this.Controls.Add(this.label1);
??? this.Cursor = System.Windows.Forms.Cursors.WaitCursor;
??? this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
??? this.Name = "frmBackUp";
??? this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
??? this.Text = "備份數據...";
??? this.Load += new System.EventHandler(this.frmBackUp_Load);
??? this.ResumeLayout(false);
?? }
?? #endregion
?? private void timer1_Tick(object sender, System.EventArgs e)
?? {
??? this.pictureBox1.Image.RotateFlip(RotateFlipType.Rotate90FlipXY);
??? this.pictureBox1.Refresh();
?? }
//?? public void setType(SetType)
//?? {
//???
?? private void frmBackUp_Load(object sender, System.EventArgs e)
?? {
??? if(this.type==(int)SetType.BackUp)
???? this.label1.Text="正在備份數據,請稍侯......";
??? else if(this.type==(int)SetType.Reinstate)
???? this.label1.Text="正在恢復數據,請稍侯......";
??? this.timer1.Start();
?? }
}
}
?
BackUpAndReinstate組件中的類:(BackUp類和Reinstate類)
BackUp類:
using System;
using System.Data;
using System.Data.SqlClient;
namespace BackUpAndReinstate
{
/// <summary>
/// 數據備份類
/// </summary>
public class BackUp
{
?? private SqlConnection con=null;?????? //數據庫連接對象
?? private string filepath=null;??????? //備份路徑
?? //單參構造
?? public BackUp(string filepath)
?? {
??? con=new SqlConnection("database=master;user id=sa;password=sa;data source=(local)");
??? this.filepath=filepath;
?? }
?? //數據備份方法
?? public string DataBaseBackUp()
?? {
??? string str="";
??? SqlCommand cmd=new SqlCommand();
??? cmd.Connection=con;
??? cmd.CommandText="select name from sysdevices where name='TeachingBusiness'";
??? con.Open();
??? SqlDataReader rdr=cmd.ExecuteReader();
??? if(!rdr.Read())
??? {
???? rdr.Close();
???? SqlCommand backcmd=new SqlCommand();
???? backcmd.Connection=con;
???? backcmd.CommandText="EXEC sp_addumpdevice @devtype,@logicalname,@physicalname";
???? SqlParameter param=backcmd.Parameters.Add("@devtype",SqlDbType.VarChar,20);
???? param.Value="disk";
???? param=backcmd.Parameters.Add("@logicalname",SqlDbType.VarChar,20);
???? param.Value="TeachingBusiness";
???? param=backcmd.Parameters.Add("@physicalname",SqlDbType.NVarChar,260);
???? param.Value=this.filepath;
???? backcmd.ExecuteNonQuery();
??? }
??? rdr.Close();
??? try
??? {
???? cmd.ExecuteNonQuery();
??? }
??? catch(SqlException er)
??? {
???? str=er.Message;
???? return str;
??? }
??? cmd.CommandText="backup database TeachingBusiness to TeachingBusiness";
??? try
??? {
???? cmd.ExecuteNonQuery();
??? }
??? catch(SqlException er)
??? {
???? str=er.Message;
???? return str;
??? }
??? finally
??? {
???? con.Close();
??? }
??? str="已備份成功!";
??? return str;
?? }
}
}
Reinstate類:
using System;
using System.Data;
using System.Data.SqlClient;
namespace BackUpAndReinstate
{
/// <summary>
/// 數據恢復類
/// </summary>
public class Reinstate
{
?? private SqlConnection con=null;??????? //數據庫連接對象
?? //默認構造
?? public Reinstate()
?? {
??? con=new SqlConnection("database=master;user id=sa;password=sa;data source=(local)");
?? }
?? //數據恢復方法
?? public string DataBaseReinstate()
?? {
??? string str="";
??? SqlCommand cmd=new SqlCommand();
??? cmd.Connection=con;
??? cmd.CommandText="RESTORE DATABASE TeachingBusiness FROM TeachingBusiness with replace";
??? con.Open();
??? try
??? {
???? cmd.ExecuteNonQuery();
??? }
??? catch(SqlException er)
??? {
???? str=er.Message;
???? return str;
??? }
??? finally
??? {
???? con.Close();
??? }
??? str="已成功恢復數據庫";
??? return str;
?? }
}
}
BackUpAndReinstate組件中的類:(BackUp類和Reinstate類)
BackUp類:
using System;
using System.Data;
using System.Data.SqlClient;
namespace BackUpAndReinstate
{
/// <summary>
/// 數據備份類
/// </summary>
public class BackUp
{
?? private SqlConnection con=null;?????? //數據庫連接對象
?? private string filepath=null;??????? //備份路徑
?? //單參構造
?? public BackUp(string filepath)
?? {
??? con=new SqlConnection("database=master;user id=sa;password=sa;data source=(local)");
??? this.filepath=filepath;
?? }
?? //數據備份方法
?? public string DataBaseBackUp()
?? {
??? string str="";
??? SqlCommand cmd=new SqlCommand();
??? cmd.Connection=con;
??? cmd.CommandText="select name from sysdevices where name='TeachingBusiness'";
??? con.Open();
??? SqlDataReader rdr=cmd.ExecuteReader();
??? if(!rdr.Read())
??? {
???? rdr.Close();
???? SqlCommand backcmd=new SqlCommand();
???? backcmd.Connection=con;
???? backcmd.CommandText="EXEC sp_addumpdevice @devtype,@logicalname,@physicalname";
???? SqlParameter param=backcmd.Parameters.Add("@devtype",SqlDbType.VarChar,20);
???? param.Value="disk";
???? param=backcmd.Parameters.Add("@logicalname",SqlDbType.VarChar,20);
???? param.Value="TeachingBusiness";
???? param=backcmd.Parameters.Add("@physicalname",SqlDbType.NVarChar,260);
???? param.Value=this.filepath;
???? backcmd.ExecuteNonQuery();
??? }
??? rdr.Close();
??? try
??? {
???? cmd.ExecuteNonQuery();
??? }
??? catch(SqlException er)
??? {
???? str=er.Message;
???? return str;
??? }
??? cmd.CommandText="backup database TeachingBusiness to TeachingBusiness";
??? try
??? {
???? cmd.ExecuteNonQuery();
??? }
??? catch(SqlException er)
??? {
???? str=er.Message;
???? return str;
??? }
??? finally
??? {
???? con.Close();
??? }
??? str="已備份成功!";
??? return str;
?? }
}
}
Reinstate類:
using System;
using System.Data;
using System.Data.SqlClient;
namespace BackUpAndReinstate
{
/// <summary>
/// 數據恢復類
/// </summary>
public class Reinstate
{
?? private SqlConnection con=null;??????? //數據庫連接對象
?? //默認構造
?? public Reinstate()
?? {
??? con=new SqlConnection("database=master;user id=sa;password=sa;data source=(local)");
?? }
?? //數據恢復方法
?? public string DataBaseReinstate()
?? {
??? string str="";
??? SqlCommand cmd=new SqlCommand();
??? cmd.Connection=con;
??? cmd.CommandText="RESTORE DATABASE TeachingBusiness FROM TeachingBusiness with replace";
??? con.Open();
??? try
??? {
???? cmd.ExecuteNonQuery();
??? }
??? catch(SqlException er)
??? {
???? str=er.Message;
???? return str;
??? }
??? finally
??? {
???? con.Close();
??? }
??? str="已成功恢復數據庫";
??? return str;
?? }
}
}