亚洲免费在线-亚洲免费在线播放-亚洲免费在线观看-亚洲免费在线观看视频-亚洲免费在线看-亚洲免费在线视频

c#中數據庫的備份和恢復

系統 1986 0

//數據備份菜單點擊事件
?? 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;
?? }
}
}

?

c#中數據庫的備份和恢復


更多文章、技術交流、商務合作、聯系博主

微信掃碼或搜索:z360901061

微信掃一掃加我為好友

QQ號聯系: 360901061

您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點擊下面給點支持吧,站長非常感激您!手機微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點擊微信右上角掃一掃功能,選擇支付二維碼完成支付。

【本文對您有幫助就好】

您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描上面二維碼支持博主2元、5元、10元、自定義金額等您想捐的金額吧,站長會非常 感謝您的哦!!!

發表我的評論
最新評論 總共0條評論
主站蜘蛛池模板: 久久精品女人天堂 | 亚洲综合在线播放 | 91精品久久久久亚洲国产 | 特级生活片 | 欧美在线一级毛片观看 | 欧美精品成人一区二区在线观看 | 国产福利影院在线观看 | 狠狠色狠狠干 | 老子影院午夜伦不卡 | 京野结衣免费一区二区 | 中文字幕亚洲国产 | 国产真实乱xxxav | 欧美兽皇另类 | 久久这里只有精品2 | 国产日韩精品一区二区在线观看 | 国产精品99久久久久久小说 | 日本在线播放一区 | 草草影院第一页yycccom | 国产一区二区不卡免费观在线 | 伊人成综合| 久久的爱久久的你 | 欧美一区二区久久精品 | 午夜影院福利 | 欧美人成毛片在线播放 | 99久久精品免费看国产一区二区 | 和日本免费不卡在线v | 伊人网综合 | 国产精品视频一区国模私拍 | 手机看片神马午夜片 | 青青青青青国产免费观看 | 国产乱子伦手机在线 | 国产香蕉久久 | 色综合久久天天综线观看 | 国产精品视频第一区二区 | 欧美一级毛片欧美毛片视频 | 日本在线视频精品 | 久久久噜噜噜 | 欧美日韩国产58香蕉在线视频 | 99视频在线免费看 | 日韩一区二区中文字幕 | 欧美一级毛片欧美毛片视频 |