91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 1.16MB
    文件類型: .rar
    金幣: 2
    下載: 0 次
    發布日期: 2023-11-12
  • 語言: C#
  • 標簽: SQL??數據庫??

資源簡介

本模塊主要實現了備份數據庫、還原數據庫功能。在對數據庫進行操作前，首先需要選擇服務器，及輸入相應的用戶名和密碼，進行登錄，然后才能對數據庫進行操作。單擊“備份數據庫”按鈕，打開“備份本地數據庫”窗口，如圖1.2所示。輸入備份文件名，選擇要備份的數據庫，然后再選擇保存備份文件的路徑，單擊“確定”按鈕對數據庫進行備份。

資源截圖

代碼片段和文件信息 

using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;
namespace?SQL_Distill
{
????public?partial?class?frmAppend?:?Form
????{
????????public?frmAppend（）
????????{
????????????InitializeComponent（）;
????????}
????????public?string?strserver?=?““;
????????public?string?struser?=?““;
????????public?string?strpwd?=?““;
????????private?void?button3_Click（object?sender?EventArgs?e）
????????{
????????????this.Close（）;
????????}

????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????if?（openFileDialog1.ShowDialog（）?==?DialogResult.OK）
????????????{
????????????????textBox1.Text?=?openFileDialog1.FileName;
????????????}
????????}

????????private?void?button2_Click（object?sender?EventArgs?e）
????????{
????????????if?（textBox1.Text.Trim（）?==?““）
????????????{
????????????????MessageBox.Show（“注意：信息不完整！“?“警告“?MessageBoxButtons.OK?MessageBoxIcon.Exclamation）;
????????????}
????????????else
????????????{
????????????????using?（SqlConnection?con?=?new?SqlConnection（“server=.;pwd=“?+?strpwd?+?“;uid=“?+?struser?+?“;database=master“））
????????????????{
????????????????????try
????????????????????{
????????????????????????string[]?getInfo?=?new?string[2];
????????????????????????string?mdfpath?=?textBox1.Text.Trim（）;//mdf路徑
????????????????????????string?DataName?=?mdfpath.Substring（mdfpath.LastIndexOf（“\\“）+1mdfpath.Length-mdfpath.LastIndexOf（“\\“）-1）;
????????????????????????DataName?=?DataName.Remove（DataName.LastIndexOf（“_“））;
????????????????????????string?logName?=mdfpath.Remove（mdfpath.LastIndexOf（“\\“））+“\\“+DataName?+?“_log.ldf“;
????????????????????????SqlCommand?cmd?=?new?SqlCommand（）;
????????????????????????con.Open（）;
????????????????????????cmd.Connection?=?con;
????????????????????????StringBuilder?sb?=?new?StringBuilder（）;
????????????????????????sb.Append（“sp_attach_db?@dbname=‘“?+?DataName?+?“‘“）;
????????????????????????sb.Append（“@filename1=‘“?+?mdfpath?+?“‘“）;
????????????????????????if?（System.IO.File.Exists（logName））
????????????????????????{
????????????????????????????sb.Append（“@filename2=‘“?+?logName?+?“‘“）;
????????????????????????}
????????????????????????else
????????????????????????{
????????????????????????????MessageBox.Show（“注意：缺少必備的log文件！“?“警告“?MessageBoxButtons.OK?MessageBoxIcon.Exclamation）;
????????????????????????}
????????????????????????cmd.CommandText?=?sb.ToString（）;
????????????????????????cmd.ExecuteNonQuery（）;
????????????????????????con.Close（）;
????????????????????????MessageBox.Show（“提示：附加成功！“?“提示“?MessageBoxButtons.OK?MessageBoxIcon.Exclamation）;
????????????????????????getInfo[0]?=?mdfpath.Substring（mdfpath.LastIndexOf（“\\“）?+?1?mdfpath.Length?-?mdfpath.LastIndexOf（“\\“）?-?1）;
????????????????????????getInfo[1]?=?mdfpath;
????????????????????????ListViewItem?lvi?=

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????5632??2005-12-08?14:51??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\bin\Debug\SQL-Distill.vshost.exe

?????文件???????3437??2008-07-29?16:59??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\frmAppend.cs

?????文件???????7265??2008-07-29?15:35??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\frmAppend.Designer.cs

?????文件???????6017??2008-07-29?15:35??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\frmAppend.resx

?????文件???????3608??2008-08-18?10:39??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\frmBackup.cs

?????文件???????7022??2008-07-29?15:34??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\frmBackup.Designer.cs

?????文件???????6022??2008-07-29?15:34??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\frmBackup.resx

?????文件???????6765??2008-07-31?09:16??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\frmDataExport.cs

?????文件???????7564??2008-07-30?08:28??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\frmDataExport.Designer.cs

?????文件???????6017??2008-07-30?08:28??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\frmDataExport.resx

?????文件??????13851??2008-08-21?09:25??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\frmMain.cs

?????文件??????22806??2008-08-04?13:39??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\frmMain.Designer.cs

?????文件??????15513??2008-08-04?13:39??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\frmMain.resx

?????文件???????7001??2008-08-04?12:59??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\frmOutData.cs

?????文件???????7601??2008-07-30?14:32??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\frmOutData.Designer.cs

?????文件???????6017??2008-07-30?14:32??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\frmOutData.resx

?????文件???????3305??2008-07-31?08:44??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\frmRevert.cs

?????文件???????6667??2008-07-29?13:20??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\frmRevert.Designer.cs

?????文件???????6017??2008-07-29?13:20??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\frmRevert.resx

?????文件?????409600??2013-03-05?09:14??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\obj\Debug\Interop.Microsoft.Office.Core.dll

?????文件????1273856??2013-03-05?09:14??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\obj\Debug\Interop.Microsoft.Office.Interop.Excel.dll

?????文件?????778240??2013-03-05?09:14??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\obj\Debug\Interop.Microsoft.Office.Interop.Word.dll

?????文件?????950272??2013-03-05?09:14??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\obj\Debug\Interop.SQLDMO.dll

?????文件??????57344??2013-03-05?09:14??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\obj\Debug\Interop.VBIDE.dll

?????文件???????1159??2013-03-05?09:14??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\obj\Debug\SQL-Distill.csproj.GenerateResource.Cache

?????文件????????873??2013-03-05?09:14??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\obj\Debug\SQL-Distill.csproj.ResolveComReference.cache

?????文件????????180??2013-03-05?09:14??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\obj\Debug\SQL_Distill.frmAppend.resources

?????文件????????180??2013-03-05?09:14??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\obj\Debug\SQL_Distill.frmBackup.resources

?????文件????????180??2013-03-05?09:14??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\obj\Debug\SQL_Distill.frmDataExport.resources

?????文件???????7079??2013-03-05?09:14??SQL數據備份恢復程序\SQL-Distill\Backup\SQL-Distill\obj\Debug\SQL_Distill.frmMain.resources

............此處省略96個文件信息

評論

共有 條評論