title: C# DataAdapter, DataTable -> not updating back to SQL Server table
body: <p>I wrote a simple test to check my dataAdapter code. I connect to the SQL Server database, fill a datatable, change a value in a row, and call <code>da.Update(table)</code> to send the changes back to SQL Server. The table has a primary key. Not at all sure why this isn't working...(see code)</p>
  
  <pre><code>connectionToSQL = new SqlConnection(SQLConnString);
  connectionToSQL.Open();
  
  var wktbl = new DataTable();
  
  var cmd = new SqlCommand("SELECT * FROM TAGS$",connectionToSQL);                 
  var da = new SqlDataAdapter(cmd);
  var b = new SqlCommandBuilder(da);
  da.Fill(wktbl);
  
  wktbl.Rows[3][2] = "5";
  wktbl.AcceptChanges();
  
  da.Update(wktbl);
  </code></pre>