利用datagridview控件编辑数据库，并实现源数据库实时修改

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.OleDb;namespace studentMessage{ public partial class stumessage : Form { public stumessage() { InitializeComponent(); } OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:/Documents and Settings/Administrator/桌面/StudentMessage/xueji.accdb;Persist Security Info=False"); OleDbDataAdapter da4; DataSet ds4; private void button2_Click(object sender, EventArgs e) { try { OleDbCommand comm = new OleDbCommand("select Sno as 学号,Sname as 姓名,Ssex as 性别,Sbirth as 出生日期,Sid as 身份证号,Sminzu as 民族,Smianmao as 面貌,Splace as 出生地,Stel as 手机号,Sjointime as 入学时间,Spwd as 密码 from allstudent_message", conn); if (conn.State != ConnectionState.Open) { conn.Open(); } da4 = new OleDbDataAdapter(comm); ds4 = new DataSet(); da4.Fill(ds4); dataGridView1.DataSource = ds4.Tables[0].DefaultView; OleDbCommandBuilder db = new OleDbCommandBuilder(da4 ); } catch (Exception ex) { // MessageBox.Show(ex .Message ); conn.Close(); } } private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e) { try { da.Update(ds.Tables[0]);//更新数据库 ds.Tables[0].AcceptChanges();//提交更新的数据集到源数据库 conn.Close(); } catch (Exception ex) { conn.Close(); MessageBox.Show("请联系管理员！"+ex .Message ); } } }}