title: Update using MySqlDataAdapter doesn't work
body: <p>I am trying to use MySqlDatAdapter to update a MySql table. But, the table never updates!!! I did this before but with SQL server. Is there anything else that is specific to MySql that I am missing in my code?</p>
  
  <pre><code>        DataTable myTable = new DataTable("testtable");
  
          MySqlConnection mySqlCon = new MySqlConnection(ConfigurationManager.ConnectionStrings["DBConStr"].ConnectionString);
  
          MySqlCommand mySqlCmd = new MySqlCommand("SELECT * FROM testtable WHERE Name = 'Tom'");
          mySqlCmd.Connection = mySqlCon;
  
          MySqlDataAdapter adapter = new MySqlDataAdapter(mySqlCmd);
          MySqlCommandBuilder myCB = new MySqlCommandBuilder(adapter);
          adapter.UpdateCommand = myCB.GetUpdateCommand();
  
          mySqlCon.Open();
  
          adapter.Fill(myTable);
          myTable.Rows[0]["Name"] = "Was Tom";
          myTable.AcceptChanges();
          adapter.Update(myTable);
          mySqlCon.Close();
  </code></pre>
  
  <p>Thanks</p>