C# SqlCommandBuilder更新数据库?

Question

请看如下代码:
        private IAdapter ada = new SqlAdapter();
        private SqlDataAdapter da;
        private DataSet ds;        private void btShow_Click(object sender, EventArgs e)
        {
            ds = new DataSet();
            da = ada.adapter("SELECT * FROM late");//方法,返回SqlDataAdapter
            da.Fill(ds);            bindingSource1.DataSource = ds;
            bindingNavigator1.BindingSource = bindingSource1;
            dataGridView1.DataSource = ds.Tables[0];
        }        private void toolSave_Click(object sender, EventArgs e)
        {
            SqlCommandBuilder scb = new SqlCommandBuilder(da);
            //ds.AcceptChanges();
            da.Update(ds);
        }此上代码不报错,但是也不更新数据库?
出了什么问题呢?

Answer 1

private SqlDataAdapter da;
private DataSet ds;private void btShow_Click(object sender, EventArgs e)
{
    ds = new DataSet();
    da = new SqlDataAdapter("SELECT * FROM late","连接语句");
    da.Fill(ds);    bindingSource1.DataSource = ds;
    bindingNavigator1.BindingSource = bindingSource1;
    dataGridView1.DataSource = ds.Tables[0];
}private void toolSave_Click(object sender, EventArgs e)
{
     SqlCommandBuilder scb = new SqlCommandBuilder(da);
     da.Update(ds);
     ds.AcceptChanges();
}

Answer 2

        private IAdapter ada = new SqlAdapter();
        private SqlDataAdapter da;
        private DataSet ds;        private void btShow_Click(object sender, EventArgs e)
        {
            ds = new DataSet();
            da = ada.adapter("SELECT * FROM late");//方法,返回SqlDataAdapter
            SqlCommandBuilder scb = new SqlCommandBuilder(da);
            da.Fill(ds);            bindingSource1.DataSource = ds;
            bindingNavigator1.BindingSource = bindingSource1;
            dataGridView1.DataSource = ds.Tables[0];
        }        private void toolSave_Click(object sender, EventArgs e)
        {
            
            //ds.AcceptChanges();
            da.Update(ds);
        }

Answer 3

我问题没有描述清楚,LS代码也不能更新
toolSave是bindingNavigator上面的按扭,自已添加的
经过半夜奋战,问题就发生在这儿,如果是个单独的按纽则所有LS的代码均没有问题~http://blog.csdn.net/hwj383/archive/2008/05/08/2414935.aspx