private DataSet ds = new DataSet();//数据库操作

        private void button4_Click(object sender, EventArgs e)
        {
        string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=G:\\Users\\jiong\\Desktop\\BMS\\BMS\\BMS_data.accdb";
        string sql = "select * from 博达电池数据表";
        OleDbConnection connection = new OleDbConnection(connectionString);
        OleDbDataAdapter dataAdapter = new OleDbDataAdapter(sql, connection);
        dataAdapter.Fill(ds);
        dataGridView1.DataSource = ds.Tables[0].DefaultView;
        dataGridView1.AllowUserToAddRows = false;
        }

            OleDbConnection connection = new OleDbConnection(connectionString);
            OleDbDataAdapter dataAdapter = new OleDbDataAdapter(sql, connection); 
            dataAdapter.Fill(ds);
            dataGridView1.DataSource = ds.Tables[0].DefaultView;
            dataGridView1.AllowUserToAddRows = false;//通常 DataGridView 的最下面一行是用户新追加的行（行头显示 * ）。
                                                    //如果不想让用户新追加行即不想显示该新行，可以将 DataGridView 对象的 AllowUserToAddRows 属性设置为 False。

        private void button4_Click(object sender, EventArgs e)
        {
        OleDbConnection connection = new OleDbConnection(connectionString);
        OleDbDataAdapter dataAdapter = new OleDbDataAdapter(sql, connection);
        OleDbCommandBuilder cb = new OleDbCommandBuilder(dataAdapter); // 创建OleDbCommandBuilder对象cb用于更新OleDbDataAdapter对象da的Insert、Delete、Update指令
        dataAdapter.UpdateCommand = cb.GetUpdateCommand(); //更新OleDbDataAdapter对象da的指令
        dataAdapter.Update(ds); //更新数据库
        
        //-------重新绑定dataGridView的数据源，以便重新显示-------
        //dataAdapter.Fill(ds);
        //DataTable tblAuthors1;
        //tblAuthors1 = ds.Tables["博达电池数据"];
        //dataGridView1.DataSource = tblAuthors1;
        //dataAdapter.Update(ds); //更新数据库
            //dataAdapter.Fill(ds);
            //dataGridView1.DataSource = ds.Tables[0].DefaultView;
            
        }