adapt.SelectCommand.Parameters["@pK"].Value = ds1.tK[0]["id"];
adapt.Fill(ds1.spSelectDoc);
gridDoc.DataSource = ds1.spSelectDoc;

 sqlCommandBuilder1 cb = new sqlCommandBuilder1(adapt);

sqlCommandBuilder cb = new sqlCommandBuilder(adapt);

sqlCommandBuilder cb = new sqlCommandBuilder(adapt);
adapt.SelectCommand.Parameters["@pK"].Value = ds1.tK[0]["id"];
adapt.Fill(ds1.spSelectDoc);
gridDoc.DataSource = ds1.spSelectDoc;

private void button1_Click(object sender, EventArgs e)
{
gridDoc.Refresh();
adapt.Update(ds1.spSelectDoc); // error
}

public void UpdateDataSet()
{
  DataSet dataSet = new DataSet();
  DataTable tbl = dataSet.Tables.Add("EMPLOYEE");

  using(OleDbConnection con = ConnectionProvider.CreateConnection())
  {
    con.Open();        
    OleDbDataAdapter adapter = 
      new OleDbDataAdapter("select * from EMPLOYEE", con);
    adapter.SelectCommand.Transaction = con.BeginTransaction();
    adapter.Fill(tbl);

    // вносим изменения в DataSet
    foreach (DataRow row in tbl.Rows)
      row["FIRST_NAME"] = row["FIRST_NAME"].ToString().ToUpper();

    // генерируем команды для операций update, insert и delete 
    OleDbCommandBuilder cmdBuilder = new OleDbCommandBuilder(adapter);
    adapter.DeleteCommand = cmdBuilder.GetDeleteCommand();
    adapter.UpdateCommand = cmdBuilder.GetUpdateCommand();
    adapter.InsertCommand = cmdBuilder.GetInsertCommand(); 
 
    // обновление данных
    adapter.Update(tbl); 

    // откат сделанных изменений
    adapter.SelectCommand.Transaction.Rollback();
  }
}

adapt.SelectCommand.Parameters["@pK"].Value = ds1.tK[0]["id"];
adapt.Fill(ds1.spSelectDoc);
gridDoc.DataSource = ds1.spSelectDoc;
внес изменения в гриде
SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(adaptTDoc);
adapt.UpdateCommand = cmdBuilder.GetUpdateCommand();  // error: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.
adapt.Update(ds1.spSelectDoc);

update t1 set name=@name, doc=@doc where id=@id

adapt.SelectCommand.Parameters["@pK"].Value = ds1.tK[0]["id"];
adapt.Fill(ds1.spSelectDoc);
gridDoc.DataSource = ds1.spSelectDoc;
//внес изменения в гриде
SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(adapt);
adapt.UpdateCommand.Parameters.Add("@id", SqlDbType.Int, 10, "id");  // error: Object reference not set to an instance of an object.
adapt.UpdateCommand.Parameters.Add("@sumR", SqlDbType.Decimal, 10, "sumR");
adapt.UpdateCommand = cmdBuilder.GetUpdateCommand();  
adapt.Update(ds1.spSelectDoc);