c#中如何将datagridview中的数据存入access数据库？

1、问题描述
一个button控件得到数据显示在datagridview中，然后将datagridview显示的内容存入access数据库。
2、各路大神显身手，完整的程序悬赏20币

界面上放一个datagridview和2个按钮

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace Q758437
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        OleDbDataAdapter adp;

        private void button1_Click(object sender, EventArgs e)
        {
            OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=""C:\xxx\Q758437\db1.mdb"""); //这里换成你的数据库的位置
            adp = new OleDbDataAdapter("select * from table1", conn);
            DataTable dt = new DataTable();
            adp.Fill(dt);
            dataGridView1.DataSource = dt;
        }

        private void button2_Click(object sender, EventArgs e)
        {
            if (adp == null) return;
            var dt = (DataTable)dataGridView1.DataSource;
            OleDbCommandBuilder cmdb = new OleDbCommandBuilder(adp);
            adp.Update(dt);
        }
    }
}

完整的代码下载：https://download.csdn.net/download/caozhy/11142654
lz如果需要，留下email发给你。

师傅，一样的代码，我运行出错，几天了，查了还多资料，也设置了主键，就是报错误。求指教。
其他信息: 语法错误 (操作符丢失) 在查询表达式 '((part_name = ?) AND ((? = 1 AND part_no IS NULL) OR (part_no = ?)) AND ((? = 1 AND RGB IS NULL) OR (RGB = ?)) AND ((? = 1 AND Charger IS NULL) OR (Charger = ?)) AND ((? = 1 AND 12V IS NULL) OR (12V = ?)) AND ((? = 1 AND Bin Switch IS NULL) OR (Bin Switch' 中。