C#修改ACCESS数据库密码

来源：互联网发布：chrome js秒杀编辑：程序博客网时间：2024/05/01 22:25
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.OleDb;namespace ALTERDATABASEPASSWORD{    public partial class FrmMain : Form    {        public FrmMain()        {            InitializeComponent();        }        private void butAlterd_Click(object sender, EventArgs e)        {            //提示：参数 mode=12为独占模式            string sConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +                           "Data Source=" + Application.StartupPath + @"\HYBase.mdb;mode=12;" +                           "Persist Security Info=False;" +                           "Jet OLEDB:Database Password=123";                        System .Console .Write(sConn);            OleDbConnection MyConnection = new OleDbConnection(sConn);                                    if (MyConnection.State != ConnectionState.Open)            {                try                {                    MyConnection.Open(); //打开数据库连接                    }                catch (Exception Ex)                {                    MessageBox.Show(Ex.Message);                    return;                }            }            //"ALTER DATABASE PASSWORD 新密码 旧密码 "   null 值 为空密码            string sCmd = "ALTER DATABASE PASSWORD 456 123 ";            OleDbCommand MyCommand = new OleDbCommand(sCmd, MyConnection);            try            {                MyCommand.ExecuteNonQuery();                MessageBox.Show("OK");            }            catch (Exception Ex)            {                MessageBox.Show(Ex.Message);            }            finally            {                MyConnection.Close();                MyCommand.Dispose();            }                    }        private void button1_Click(object sender, EventArgs e)        {            //提示：参数 mode=12为独占模式            string sConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +                           "Data Source=" + Application.StartupPath + @"\SysInfoDB.mdb;mode=12;" +                           "Persist Security Info=False;" +                           "Jet OLEDB:Database Password=duan";            System.Console.Write(sConn);            OleDbConnection MyConnection = new OleDbConnection(sConn);            if (MyConnection.State != ConnectionState.Open)            {                try                {                    MyConnection.Open(); //打开数据库连接                    }                catch (Exception Ex)                {                    MessageBox.Show(Ex.Message);                    return;                }            }            //"ALTER DATABASE PASSWORD 新密码 旧密码 "   null 值 为空密码            string sCmd = "ALTER DATABASE PASSWORD 456 123 ";            OleDbCommand MyCommand = new OleDbCommand(sCmd, MyConnection);            try            {                MyCommand.ExecuteNonQuery();                MessageBox.Show("OK");            }            catch (Exception Ex)            {                MessageBox.Show(Ex.Message);            }            finally            {                MyConnection.Close();                MyCommand.Dispose();            }        }    }}
作者：段利庆（Lee） QQ：14035344