C#编程学习51：操作MDB数据库

首先导入需要的命名空间

using System.Data.OleDb;

然后在界面上添加dataGridView控件和相关按钮

功能点1：将数据库中的数据显示在界面的dataGridView控件上

         /// <summary>
        /// 将数据库中的数据显示在界面上
        /// </summary>
        public void viewAccessInfo()
        {
            //【1】连接数据库
            string connect_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=FileSys.mdb";
            OleDbConnection thisConnection = new OleDbConnection(connect_str);
            //【2】编写SQL指令，星号（*）是选取所有列的快捷方式。
            string sql = "select * from FileRecive";
            //【3】OleDbDataAdapter是 DataSet 和数据源之间的桥梁，用于检索和保存数据。
            OleDbDataAdapter thisAdapter = new OleDbDataAdapter(sql, thisConnection);
            //【4】DataSet可以理解成在应用程序中的数据库
            DataSet thisDataSet = new System.Data.DataSet();
            //使用 Fill 将数据从数据源加载到 DataSet 中
            thisAdapter.Fill(thisDataSet, "FileRecive");
            //【5】DataTable可以理解成DataSet的一个表格；将table中的表格内容添加到datatable
            DataTable dt = thisDataSet.Tables["FileRecive"];
            //【6】将数据表和dataGridView1进行绑定
            dataGridView1.DataSource = dt;
            //【7】关闭连接
            thisConnection.Close();
        }

功能点2：连接数据库并执行SQL命令

        /// <summary>
        /// 执行SQL语句
        /// </summary>
        /// <param name="sql"> 要执行的SQL语句 </param>
        /// <param name="thisConnection"> 数据库连接 </param>
        /// <returns></returns>
        public int ExcuteSql(string sql, OleDbConnection thisConnection)
        {
            int rows = 0;
            OleDbCommand cmd = new OleDbCommand(sql, thisConnection);
            thisConnection.Open();
            rows = cmd.ExecuteNonQuery();
            thisConnection.Close();
            return rows;
        }

功能点3：点击按钮，将界面上用户输入的数据记录插入的到MDB数据库中

        /// <summary>
        /// 向数据库中添加记录
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button_addItem_Click(object sender, EventArgs e)
        {
            var ID = textBox_id.Text;
            var swsj = dateTimePicker_swsj.Value;
            var swh = textBox_swh.Text;
            var lwbt = textBox_lwbt.Text;
            var zyldps = richTextBox_zyldps.Text;
            var fgldps = richTextBox_fgldps.Text;
            var cbr = textBox_cbr.Text;
            var cbsj = dateTimePicker_cbsj.Value;
            var wjgd = textBox_wjgd.Text;

            string sql = string.Format("insert into FileRecive (ID,swsj,swh,lwbt,zyldps,fgldps,cbr,cbsj,wjgd) values ('{0}', '{1}','{2}', '{3}','{4}','{5}','{6}','{7}','{8}')",
                ID, swsj, swh, lwbt, zyldps, fgldps, cbr, cbsj, wjgd);
            string connect_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=FileSys.mdb";
            OleDbConnection thisConnection = new OleDbConnection(connect_str);
            ExcuteSql(sql, thisConnection);
            thisConnection.Close();
        }

功能点4：点击按钮，将datagridview控件的内容更新到数据库

         private void button_savedata_Click(object sender, EventArgs e)
        {
            string str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=FileSys.mdb";
            OleDbConnection conn = new OleDbConnection(str);
            var dt = (DataTable)dataGridView1.DataSource;
            OleDbDataAdapter adp = new OleDbDataAdapter("select * from FileRecive", conn);
            OleDbCommandBuilder cmdb = new OleDbCommandBuilder(adp);
            adp.Update(dt);
            conn.Close();
        }