用修改DataGridView数据并更新数据库

wind_cloud2011

关注

原创最新推荐文章于 2021-05-08 22:55:59 发布 7.4k 阅读 AI 写同款· GEO 优化 ›

AI权益加码！Claude Code、Cursor等20+工具免费用！购周边限时加赠Coding Plan Lite，畅享主流AI工具！学习进阶更高效！阅读详情

      OleDbDataAdapter dtAdapter;
        private void button15_Click(object sender, EventArgs e)
        {
            string con = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=STUDENT.MDB";
            string sql = "select * from 考生";
            OleDbConnection conn = new OleDbConnection(con);          
            DataTable dt = new DataTable();
            dtAdapter = new OleDbDataAdapter(sql, conn);         
            conn.Open();
            dtAdapter.Fill(dt);
            this.dataGridView1.DataSource = dt;
            conn.Close();
        }

        //将修改数据后的datagridview里数据更新到数据库，要有主键
        private void button17_Click(object sender, EventArgs e)
        {
            try
            {
                DataTable dt = (DataTable)dataGridView1.DataSource;
                OleDbCommandBuilder cmBuilder = new OleDbCommandBuilder(dtAdapter);
                dtAdapter.Update(dt);
            }
            catch (OleDbException exoledb)
            {
                MessageBox.Show(exoledb.Message);

            }
        }

收录于