vs2008中winform应用gridveiw批量更新数据

Question

如何在vs2008中winform应用中，实现用gridveiw批量更新数据？

Answer 1

看看这个帖子吧  和你的要求一样
http://topic.csdn.net/u/20110919/14/6e510d41-ae86-40ad-875e-49d466795a6e.html

Answer 2

//将这段代码放入按钮的单击事件里面 
dt = (DataTable)DataGridView1.DataSource;
            if (dt == null)
            {
                MessageBox.Show("修改失败...");
                return;
            }
            sda.Update(dt);
            dt.AcceptChanges();
            BindDgv(DataGridView1);
            MessageBox.Show("修改成功...");

Answer 3

OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + @"\1.mdb;");
            OleDbDataAdapter adapter = new OleDbDataAdapter("select * from Alarm_history",connection);
            OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter);
            DataSet ds = new DataSet();
            adapter.Fill(ds);
            dataGridView1.DataSource = ds.Tables[0];
            //修改数据
            //修改数据
            DataTable dt = (DataTable)dataGridView1.DataSource;
            adapter.Update(dt);