Expand|Select|Wrap|Line Numbers
- 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();
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