c# 连接Access数据库，以及增删改查操作（OleDb）

---

一、数据库

1、连接

        /// <summary>
        /// 是否连接数据库，连接成功则返回True
        /// </summary>
        public bool open()
        {
            string url = Application.StartupPath + "\\database\\DatabaseBook.mdb";  //数据库路径
            string password = ""; //密码
            //连接数据库
            conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + url +
                 ";Jet OLEDB:Database Password=" + password + ";");
            try
            {
                conn.Open();
                return conn.State == System.Data.ConnectionState.Open; //判断是否打开
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
                return false;
            }
        }
        

2、关闭连接

        /// <summary>
        /// 关闭数据库连接
        /// </summary>
        public void close()
        {
           conn.Close();
        }

3、执行添加、删除、更新语句

        /// <summary>
        /// 执行添加、删除、更新语句，判断是否成功
        /// </summary>
        /// <param name="sql">要执行的sql语句</param>
        /// <returns>成功则返回True</returns>
        public bool useInsertDeleteSQL(string sql)
        {
            try
            {
                open(); //调用连接
                OleDbCommand cmd = new OleDbCommand();
                cmd = new OleDbCommand(sql, conn);
                if (cmd.ExecuteNonQuery() > 0)  //判断是否执行
                {
                    cmd.Parameters.Clear(); //清空sql语句
                    return true;
                }
                else
                {
                    return false;
                }
            }catch(Exception)
            {
                return false;
            }
        }

4、查询语句

        /// <summary>
        /// 执行查找语句
        /// </summary>
        /// <param name="sql">要执行的语句</param>
        /// <returns></returns>
        public void useSelectSQL(string sql,ref OleDbDataAdapter inst)
        {
            open();
            inst = new OleDbDataAdapter(sql, conn);
        }

                sql = "select * from Book";
                OleDbDataAdapter inst = new OleDbDataAdapter(); //实例化
                useSelectSQL(sql,ref inst);  //执行查询方法
                DataTable dt = new DataTable();  //创建DataTable
                inst.Fill(dt); 
                dataGridView1.DataSource = dt.DefaultView; //DataGridView控件中显示

DataGridView控件中显示结果如下：