title: C# SqlDataAdapter.Update()
body: <p>Im going crazy with this. I did the ff:</p>
  
  <ol>
  <li>Create a datatable.</li>
  <li>Fill it from a SQL db thru SqlDataAdapter.</li>
  <li>Edit the datatable thru datagridview.</li>
  <li>Call the sqldataadapter.update but the changes are not persisted to the db.</li>
  </ol>
  
  <p>A closer look at the datatable after editing, the row states were not updated even if i actually edited the datatable thru the datagridview but the edited DataRow(s) have changes in the item array. Really confusing.. Any ideas? Thanks.</p>