I explain the situation. I do a select from a table
Code: Select all
select * from t_mytable
I can change the row with the CurrencyManager.
The "problem" I have. When I change a a field of a record and I save, all the record have the new value, not only the selected one, I use GetUpdateCommand.
To solve the problem, I use a MySQLCommand with an update query with in the where close the id of my record. That's work.
But I have to write a big query with a lot of parameters.
Is it not possible to make an update with in argument a DataRow (just a row) without fill fields one by one ?
Thanks,