title: Add row to Access Table from DataTable
body: <p>I've used this code to create me a <code>DataTable</code> from my Access table.</p>
  
  <pre><code>DataTable dataTable = new DataTable();
  ...
  using (OleDbConnection oledbConnection = new OleDbConnection(connection))
  {
     oledbConnection.Open();
     using (OleDbCommand oledbCommand = new OleDbCommand("SELECT * FROM Student", oledbConnection))
     {
         using (OleDbDataAdapter oledbDataAdapter = new OleDbDataAdapter(oledbCommand))
         {
            oledbDataAdapter.Fill(dataTable);
         }
     }
  }
  </code></pre>
  
  <p>I later changed the datatable by inserting a new row with this code.</p>
  
  <pre><code>DataRow dataRow = dataTable.NewRow();
  dataRow["FirstName"] = "John";
  dataRow["LastName"] = "Connor";
  dataTable.Rows.Add(dataRow);
  dataTable.GetChanges();
  </code></pre>
  
  <p>How can I bring this change in my access database?
  Is correct the following code?</p>
  
  <pre><code>using (OleDbConnection oledbConnection = new OleDbConnection(connectionString))
  {
     OleDbDataAdapter oledbDataAdapter = new OleDbDataAdapter();
     oledbDataAdapter.SelectCommand = new OleDbCommand(queryString, oledbConnection);
     OleDbCommandBuilder oledbCommandBuilder = new OleDbCommandBuilder(oledbDataAdapter);
     connection.Open();
     oledbDataAdapter.DeleteCommand = oledbCommandBuilder.GetDeleteCommand(true);
     oledbDataAdapter.InsertCommand = oledbCommandBuilder.GetInsertCommand(true);
     oledbDataAdapter.UpdateCommand = oledbCommandBuilder.GetUpdateCommand(true);
     oledbDataAdapter.Update(dataTable);
     connection.Close();
  }
  </code></pre>