title: C# OleDB Save Changes
body: <pre><code>OleDbConnection connection = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=\"C:\\Users\\User\\Desktop\\New Microsoft Access Database.accdb\"");
                  OleDbDataAdapter DataAdapter = new OleDbDataAdapter("SELECT *from pinakas", connection);
  
                  DataTable pinakas_Table = new DataTable();
                  DataAdapter.Fill(pinakas_Table);
  
                  MessageBox.Show(pinakas_Table.Rows[1]["Name"].ToString());
  </code></pre>
  
  <p>OK so this line displays the name "George" of my 1st Row of field
  "Name".</p>
  
  <pre><code>        pinakas_Table.Rows[1]["Name"] = "John";
  </code></pre>
  
  <p>Now this line sets field "Name" the value "John"</p>
  
  <pre><code>        pinakas_Table.AcceptChanges();
          DataAdapter.Fill(pinakas_Table);
          MessageBox.Show(pinakas_Table.Rows[1]["Name"].ToString());
  </code></pre>
  
  <p>OK now my app displays the name "John" ! That means the DataTable "pinakas_Table" got the Change.</p>
  
  <pre><code>        DataAdapter.Update(pinakas_Table);
  </code></pre>
  
  <p>But it's never saved to my Access database.</p>