<del id="d4fwx"><form id="d4fwx"></form></del>
      <del id="d4fwx"><form id="d4fwx"></form></del><del id="d4fwx"><form id="d4fwx"></form></del>

            <code id="d4fwx"><abbr id="d4fwx"></abbr></code>
          • vb.net文件夾備份,如何備份vbios

            vb.net怎么實(shí)現(xiàn)數(shù)據(jù)庫的復(fù)制備份

            Access 數(shù)據(jù)庫備份時(shí).需要關(guān)閉數(shù)據(jù)庫的連接后才能進(jìn)行備份操作.也就是復(fù)制操作.

            成都地區(qū)優(yōu)秀IDC服務(wù)器托管提供商(創(chuàng)新互聯(lián)).為客戶提供專業(yè)的香港機(jī)房服務(wù)器托管,四川各地服務(wù)器托管,香港機(jī)房服務(wù)器托管、多線服務(wù)器托管.托管咨詢專線:13518219792

            VB.NET備份SQL數(shù)據(jù)庫

            using System;

            using System.Data;

            using System.Configuration;

            using System.Collections;

            using System.Web;

            using System.Web.Security;

            using System.Web.UI;

            using System.Web.UI.WebControls;

            using System.Web.UI.WebControls.WebParts;

            using System.Web.UI.HtmlControls;

            using System.IO;

            using System.Text;

            using _5dRss.Const;

            using _5dRss.lib.Data.Tool;

            public partial class admin_admin_dbmanage : System.Web.UI.Page

            {

            protected void Page_Load(object sender, EventArgs e)

            {

            //生成備份文件列表

            ListBackupFiles();

            if (!Page.IsPostBack)

            {

            Showmsg.Visible = false;

            //數(shù)據(jù)庫路徑

            lilDBPath.Text = HttpContext.Current.Request.PhysicalApplicationPath + "App_Data\\" + ConfigurationSettings.AppSettings["DBFile"];

            //新建一個(gè) FileInfo 對象,并獲得數(shù)據(jù)庫文件的大小,然后轉(zhuǎn)換單位為KB

            FileInfo myFileInfo = new FileInfo(lilDBPath.Text);

            lilDBSize.Text = Convert.ToString(myFileInfo.Length/1024) + " KB";

            //如果兩個(gè)參數(shù)都不為空,則繼續(xù)執(zhí)行

            if (Request.QueryString["cmd"] != null Request.QueryString["source"] != null)

            {

            //備份數(shù)據(jù)庫原文件名

            string sourceFileName = Request.QueryString["source"];

            //如果 cmd 參數(shù)為 DelFile

            if (Request.QueryString["cmd"].Equals("DelFile"))

            {

            //刪除備份數(shù)據(jù)庫文件

            File.Delete(HttpContext.Current.Request.PhysicalApplicationPath + "Backup\\" + sourceFileName);

            //刷新備份文件列表

            ListBackupFiles();

            Showmsg.Visible = true;

            Showmsg.Text = "div align='center' style='margin-bottom:8px;'img src='images/aL.gif' style='margin-bottom:-6px;'/span class='alertTxt'刪除備份數(shù)據(jù)庫成功!/spanimg src='images/aR.gif' style='margin-bottom:-6px;'//div";

            }

            //如果 cmd 參數(shù)為 Restore

            if (Request.QueryString["cmd"].Equals("Restore"))

            {

            //用備份文件覆蓋原文件

            File.Copy(HttpContext.Current.Request.PhysicalApplicationPath + "Backup\\" + sourceFileName, HttpContext.Current.Request.PhysicalApplicationPath + "App_Data\\" + ConfigurationSettings.AppSettings["DBFile"], true);

            //刷新備份文件列表

            ListBackupFiles();

            Showmsg.Visible = true;

            Showmsg.Text = "div align='center' style='margin-bottom:8px;'img src='images/aL.gif' style='margin-bottom:-6px;'/span class='alertTxt'還原備份數(shù)據(jù)庫成功!/spanimg src='images/aR.gif' style='margin-bottom:-6px;'//div";

            }

            }

            }

            }

            protected void lnkbtnCompactDB_Click(object sender, EventArgs e)

            {

            //壓縮修復(fù)數(shù)據(jù)庫

            AccessDBtool.CompactAccessDB(SysConfig.ConnectionString, HttpContext.Current.Request.PhysicalApplicationPath + "App_Data\\" + ConfigurationSettings.AppSettings["DBFile"]);

            Showmsg.Visible = true;

            Showmsg.Text = "div align='center' style='margin-bottom:8px;'img src='images/aL.gif' style='margin-bottom:-6px;'/span class='alertTxt'壓縮修復(fù)數(shù)據(jù)庫成功!/spanimg src='images/aR.gif' style='margin-bottom:-6px;'//div";

            }

            protected void lnkbtnBackupDB_Click(object sender, EventArgs e)

            {

            string sourceFileName = HttpContext.Current.Request.PhysicalApplicationPath + "App_Data\\" + ConfigurationSettings.AppSettings["DBFile"];

            string destFileName = HttpContext.Current.Request.PhysicalApplicationPath + "Backup\\" + "Backup_";

            destFileName += DateTime.Now.ToString("yyyyMMddHHmmss");

            destFileName += ".mbk";

            //將數(shù)據(jù)庫文件Copy到Backup目錄,如果有重名文件就覆蓋原文件

            File.Copy(sourceFileName, destFileName, true);

            //生成備份文件列表

            ListBackupFiles();

            Showmsg.Visible = true;

            Showmsg.Text = "div align='center' style='margin-bottom:8px;'img src='images/aL.gif' style='margin-bottom:-6px;'/span class='alertTxt'備份數(shù)據(jù)庫成功!/spanimg src='images/aR.gif' style='margin-bottom:-6px;'//div";

            }

            /// summary

            /// 生成備份文件列表

            /// /summary

            /// returns文件列表,文件詳細(xì)信息及操作選項(xiàng)的HTML代碼/returns

            public void ListBackupFiles()

            {

            //如果目錄不存在則創(chuàng)建次目錄

            if (!Directory.Exists(HttpContext.Current.Request.PhysicalApplicationPath + "Backup\\"))

            Directory.CreateDirectory(HttpContext.Current.Request.PhysicalApplicationPath + "Backup\\");

            DirectoryInfo mydir = new DirectoryInfo(HttpContext.Current.Request.PhysicalApplicationPath + "Backup\\");

            StringBuilder sb = new StringBuilder();

            foreach (FileInfo f in mydir.GetFiles())

            {

            sb.Append("a href='backup/" + f.Name + "' target='_blank'img border='0' src='images/mdb.gif' style='margin:4px 3px -3px 0px'/" + f.Name + "/a a href='?cmd=DelFilesource=" + f.Name + "' title='刪除備份文件'刪除/a | a href='?cmd=Restoresource=" + f.Name + "' title='刪除備份文件'還原數(shù)據(jù)庫/a | " + f.Length/1024 + " KB | " + f.CreationTime + "br /");

            }

            lilBackupFileList.Text = sb.ToString();

            }

            }

            把下面這句換成你的數(shù)據(jù)庫地址:

            //數(shù)據(jù)庫路徑

            // lilDBPath.Text = HttpContext.Current.Request.PhysicalApplicationPath + "App_Data\\" + ConfigurationSettings.AppSettings["DBFile"];

            VB.NET 復(fù)制文件夾,包括子文件夾 所有文件

            用 io.Directory.Exists 判斷文件夾是否存在。

            再用 My.Computer.FileSystem.CopyDirectory() 復(fù)制。

            分享標(biāo)題:vb.net文件夾備份,如何備份vbios
            標(biāo)題路徑:http://www.jbt999.com/article2/hedsic.html

            成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供做網(wǎng)站、服務(wù)器托管、全網(wǎng)營銷推廣網(wǎng)站維護(hù)、域名注冊、網(wǎng)站設(shè)計(jì)公司

            廣告

            聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請盡快告知,我們將會在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:[email protected]。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來源: 創(chuàng)新互聯(lián)

            小程序開發(fā)

              <del id="d4fwx"><form id="d4fwx"></form></del>
              <del id="d4fwx"><form id="d4fwx"></form></del><del id="d4fwx"><form id="d4fwx"></form></del>

                    <code id="d4fwx"><abbr id="d4fwx"></abbr></code>
                  • 看中国一级黄色片 | 日韩在线中文字幕 | 三级无码视频在线观看 | 污视频网站在线观看国产 | 无一区二区三区 |