MySqlCommandBuilder not updating the removed rows.

[nfxs]

Hi, i have writen the following code:

string mySqlCommandString = "SELECT * FROM fxs_prueba";
MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter();
mySqlDataAdapter.SelectCommand = new MySqlCommand(mySqlCommandString, mySqlConnection);
MySqlCommandBuilder mySqlCommandBuilder = new MySqlCommandBuilder(mySqlDataAdapter);
 
mySqlConnection.Open();
 
DataTable myDataTable = new DataTable("Test");
mySqlDataAdapter.Fill(myDataTable);
 
myDataTable.Rows.RemoveAt(2);
 
int rowsAffected = mySqlDataAdapter.Update(myDataTable);
 
mySqlConnection.Close();
 

But the database table is not updated. The row is still there.
It works perfect when i insert a row or modifie a row and then call the Update method.
I do not get any exceptions, it just is not working.
I use the MySQL Connector Net 5.0.6
and the table uses the MyISAM engine
What am i doing wrong?

Thanks in Advance
Felix

[nfxs]

Hellooo!!
Anyone?
(is it now 20 chars long?)

[r035198x]

Hellooo!!
Anyone?
(is it now 20 chars long?)

Aren,t you supposed to call some refresh method like AcceptChanges or something fo the changes to show?
P.S I think this is best handled in the .NET forum so I'll copy it there.

[RoninZA]

This is not the ideal way to be deleting rows out of a table, but if you insist on using a data adapter, you need to set the delete command peoperty, and delete the missing rows one for one...

Hope it helps!