title: Help with updating access database using Update(dataTable)
body: <p>I have looked all over the place but I cant seem to get this to work.</p>
  
  <p>I am trying to update an Access database from  a DataGridView. The loading of the database to the grid works fine. I used the instructions described in <a href="http://www.switchonthecode.com/tutorials/csharp-tutorial-binding-a-datagridview-to-a-database" rel="nofollow">this site</a>. </p>
  
  <p>However, to update the database based on changes made to the DataGridView, I used the command <code>dataAdapter.Update(datatable);</code>, but depending on the placement (next to this code) the code runs but the database does not update.  If I put it in a button it throws an exception "syntax error in insert into statement".</p>
  
  <p>Other question: Should I close the connection variable after loading the DataGridView? If so, should I reopen it to perform the update and then reclose it? How does that work?.</p>
  
  <p>Any help would be greatly appreciated. 
  EDIT: Putted whole class as Tim asked.</p>
  
  <pre><code> public partial class Pantalla_Proyecto : Form
  {
      private Inicio Inicio;
      private List&lt;string&gt; Logueado;
      private OleDbConnection conn;
      private OleDbDataAdapter Adaptador;
      private DataTable Tabla;
      private BindingSource Bsource;
      private OleDbCommandBuilder Builder;
  
      public Pantalla_Proyecto(Inicio Inicio, List&lt;string&gt; Logueado)
      {
          this.Inicio =Inicio;
          this.Logueado = Logueado;
          InitializeComponent();
      }
      private void Pantalla_Proyecto_Load(object sender, EventArgs e)
      {
      }
  
       private void importarCDPToolStripMenuItem_Click(object sender, EventArgs e)
      {
          Importar_CDP Importar_CDP = new Importar_CDP();
          Importar_CDP.Show();
      }
  
      private void importarListasToolStripMenuItem_Click(object sender, EventArgs e)
      {
          WindowsFormsApplication1.Formularios.Lista_Lazos.Importar_Listas1 Importar_Listas = new WindowsFormsApplication1.Formularios.Lista_Lazos.Importar_Listas1();
          Importar_Listas.Show();
      }
  
      private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
      {
  
      }
  
      private void button1_Click(object sender, EventArgs e)
      {
  
      }
  
      private void flowLayoutPanel2_Paint(object sender, PaintEventArgs e)
      {
  
      }
  
      private void menuStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
      {
  
      }
  
      private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
      {
          string sql = "Select *  From ["+TABLE (THIS IS A STRING I GET FROM PREVIOUS FORM)+"]";
          conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=proyectos\" + Location(this is a string i get on the previous form) + ".mdb;User Id=admin;Password=;");
          conn.Open();
  
          //  Extraemos info de mi database y la meto en un datatable
          Adaptador = new OleDbDataAdapter(sql, conn);
          Builder = new OleDbCommandBuilder(Adaptador);
          Tabla = new DataTable();
          Adaptador.Fill(Tabla);
  
          // LLENO EL DATA GRID VIEW
          Bsource = new BindingSource();
          Bsource.DataSource = Tabla;
          dataGridView1.DataSource = Bsource;
          dataGridView1.Dock = DockStyle.Fill;
          Adaptador.Update(Tabla);//if i put it here nothing happens
          conn.Close();
  
  
      }
  
      private void dataGridView1_Validating(object sender, CancelEventArgs e)
      {
  
      }
  
      private void button1_Click_1(object sender, EventArgs e)
      {
          conn.Open();
          Adaptador.Update(Tabla);//IF i put it here i get an exception
          conn.Close();
      }
  </code></pre>