c# 存储 过程操作数据库 附加、分离数据库

【实例截图】

【核心代码】

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Threading;
using System.Diagnostics;

namespace OperateDB
{
    public partial class MaiForm : Form
    {
        private static MaiForm instance;
        private static readonly object padlock = new object();
        private MaiForm()
        {
            InitializeComponent();
        }

        public static MaiForm GetInstance()
        {
            lock (padlock)
            {
                if (instance == null || instance.IsDisposed)
                {
                    instance = new MaiForm(); 
                }
                return instance;
            }
        }

        private void MaiForm_Load(object sender, EventArgs e)
        {
            InitComboBox();
        }

        //附加
        private void btnAttach_Click(object sender, EventArgs e)
        {
            string mdfPath = this.txtDBPath.Text.Trim();
            if (string.IsNullOrEmpty(mdfPath))
            {
                MessageBox.Show("请选择数据库");
                this.txtDBPath.Focus();
                return;
            }
            try
            {
                string DBName = mdfPath.Substring(mdfPath.LastIndexOf("\\")   1);
                if (DBName.Substring(DBName.LastIndexOf(".")).ToLower() != ".mdf")
                {
                    MessageBox.Show("数据库格式不正确(*.mdf)");
                    return;
                }
                DBName = DBName.Substring(0, DBName.LastIndexOf("."));
                string ldfPath = mdfPath.Substring(0, mdfPath.LastIndexOf("."))   "_log.ldf";
                SQLHelper.AttachDataBase(DBName, mdfPath, ldfPath);
                InitComboBox();
                MessageBox.Show("附加成功");

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void btnOpen_Click(object sender, EventArgs e)
        {
            this.openFileDialog1.ShowDialog();
            this.txtDBPath.Text = this.openFileDialog1.FileName;
        }

        //分离
        private void btnDetach_Click(object sender, EventArgs e)
        {
            string dbName = this.cboDBName.Text;
            int dbId = Convert.ToInt32(this.cboDBName.SelectedValue);
            try
            {
                SQLHelper.Dispope(dbId);
                SQLHelper.DetachDataBase(this.cboDBName.Text);
                InitComboBox();
                MessageBox.Show("分离成功");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        //刷新
        private void button1_Click(object sender, EventArgs e)
        {
            InitComboBox();
        }

        /// <summary>
        /// 初始化选择数据库下拉框
        /// </summary>
        private void InitComboBox()
        {
            this.cboDBName.DataSource = SQLHelper.GetDataBases();
            this.cboDBName.DisplayMember = "name";
            this.cboDBName.ValueMember = "database_id";
        }

        private void tsmiExit_Click(object sender, EventArgs e)
        {
            //this.Close();
            //this.Dispose();
            Application.ExitThread();
        }

        private void MaiForm_FormClosing(object sender, FormClosingEventArgs e)
        {
            e.Cancel = true;
            this.Hide();
        }

        private void notifyIcon1_MouseClick(object sender, MouseEventArgs e)
        {
            if (e.Button == MouseButtons.Left)
            {
                this.Visible = true;
                this.Activate();
            }
        }

        private void tsmiShow_Click(object sender, EventArgs e)
        {
            this.Visible = true;
            this.Activate();
        }

        /// <summary> 
        /// 操作系统关闭时，关闭应用程序 
        /// </summary> 
        /// <param name="m">截获系统消息</param> 
        protected override void WndProc(ref Message m)
        {
            switch (m.Msg)
            {
                case 0x0011://WM_QUERYENDSESSION 
                    m.Result = (IntPtr)1;
                    break;
                default:
                    base.WndProc(ref m);
                    break;
            }
        }
        
        private void MaiForm_DragEnter(object sender, DragEventArgs e)
        {
            if (e.Data.GetDataPresent(DataFormats.FileDrop))
            {
                e.Effect = DragDropEffects.Link;
            }
            else
            {
                e.Effect = DragDropEffects.None;
            }
        }

        private void MaiForm_DragDrop(object sender, DragEventArgs e)
        {
            txtDBPath.Text = ((System.Array)e.Data.GetData(DataFormats.FileDrop)).GetValue(0).ToString(); 
        }

        //当windows操作系统执行关闭动作时,它会发送给各个正在运行的应用程序一个消息WM_QUERYENDSESSION,
        //告诉应用程序要关机了,如果反馈回来的消息值为1,那么windows操作系统就会自动关闭.
        //因此,通过截获WM_QUERYENDSESSION消息,就能实现自动退出程序
    }
}