关于dataGridView控件问题

[lxz_jxmz1125]

我是用本地的access数据库：
namespace WindowsApplication2
{
public partial class Form1 : Form
{
private DataTable DT = new DataTable();
private OleDbDataAdapter odb = new OleDbDataAdapter();
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
string strCon = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\a\db1.mdb";
OleDbConnection MyCon = new OleDbConnection(strCon);
MyCon.Open();
OleDbCommand scd = new OleDbCommand("select * from [table]", MyCon);
odb.SelectCommand = scd;
odb.Fill(DT);
dataGridView1.DataSource = DT;
}
private void button2_Click(object sender, EventArgs e)
{
try
{
OleDbCommandBuilder cmdbuilder = new OleDbCommandBuilder(odb);

odb.Update(DT);

}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString());

return;
}
MessageBox.Show("更新成功!");



}
}


}
上面是我的程序，用的是windows程序.运行程序时，在dataGridView中载入数据库中的数据（已成功），但是在dataGridView中更改数据后，单击按钮时，会报“system.data.oledb.oledbexception update 错误”。我上网查了，有的说是权限的问题，有的说是表中关键字问题，但我查看后，本系统用户是所有权限阿，而且表中也设置了主键。因为我刚学，所以请高手们详细帮我解答，到底是哪里的问题。我只想要程序已运行就把数据库中的数据显示在表中，当表中的数据修改后，点击按钮就可以更改数据库中的数据。我只要完成这个功能就行。

[jacklee_008]

odb.Update(((DataTable)DT.DataSource);

[贫僧又回来了]

是不是你修改后的数据的类型与数据库中定义的类型不同啊!

[68435970]

        private void Form1_Load(object sender, EventArgs e) 
        { 
            string strCon = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\a\db1.mdb"; 
            OleDbConnection MyCon = new OleDbConnection(strCon); 
             MyCon.Open(); 
            DataTable DT = new DataTable(); 
            OleDbDataAdapter odb = new OleDbDataAdapter("select * from [table]", MyCon); 
            odb.Fill(DT); 
            dataGridView1.DataSource = DT; 
        } 
       private void button2_Click(object sender, EventArgs e) 
        { 
            try 
            { 
               OleDbConnection MyCon = new OleDbConnection(strCon); 
               MyCon.Open(); 
               OleDbDataAdapter odb = new OleDbDataAdapter("select * from [table]", MyCon);  
               OleDbCommandBuilder cmdbuilder = new OleDbCommandBuilder(odb); 
               odb.Update(DT);  
            } 
            catch (System.Exception ex) 
            { 
                MessageBox.Show(ex.ToString()); 
                return; 
            } 
            MessageBox.Show("更新成功!"); 
        } 

[jacklee_008]

namespace WindowsApplication2
{
public partial class Form1 : Form
{
private DataTable DT = new DataTable();
private OleDbDataAdapter odb = new OleDbDataAdapter();
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
string strCon = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\a\db1.mdb";
OleDbConnection MyCon = new OleDbConnection(strCon);
MyCon.Open();
OleDbCommand scd = new OleDbCommand("select * from [table]", MyCon);
odb.SelectCommand = scd;
odb.Fill(DT);
dataGridView1.DataSource = DT;
}
private void button2_Click(object sender, EventArgs e)
{
try
{
// OleDbCommandBuilder cmdbuilder = new OleDbCommandBuilder(odb); //去掉这句话

odb.Update(DT);

}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString());

return;
}
MessageBox.Show("更新成功!");



}
}

[jacklee_008]

private void button2_Click(object sender, EventArgs e)
{
try
{
// OleDbCommandBuilder cmdbuilder = new OleDbCommandBuilder(odb); //去掉这句话

odb.Update(((DataTable)DT.DataSource);
}

[68435970]

      DataTable DT = new DataTable(); 
        private void Form1_Load(object sender, EventArgs e) 
        { 
            string strCon = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\a\db1.mdb"; 
            OleDbConnection MyCon = new OleDbConnection(strCon); 
             MyCon.Open(); 
            OleDbDataAdapter odb = new OleDbDataAdapter("select * from [table]", MyCon); 
            odb.Fill(DT); 
            dataGridView1.DataSource = DT; 
        } 
       private void button2_Click(object sender, EventArgs e) 
        { 
            try 
            { 
               OleDbConnection MyCon = new OleDbConnection(strCon); 
               MyCon.Open(); 
               OleDbDataAdapter odb = new OleDbDataAdapter("select * from [table]", MyCon);  
               OleDbCommandBuilder cmdbuilder = new OleDbCommandBuilder(odb); 
               odb.Update(DT);  
            } 
            catch (System.Exception ex) 
            { 
                MessageBox.Show(ex.ToString()); 
                return; 
            } 
            MessageBox.Show("更新成功!"); 
        } 
 这样就可以解决你的问题了