Is there anybody can help me?
I just installed MYSQLDIRECT evaulation ODBC and created a testing program. I can read the data in the datagrid with the MYSQLDIRECT ODBC but I can't update it in the Mysql server.
'I added this code in the form load event.
MySqlDataAdapter1.Fill(DataSet11, "table")
'I added this code in the save event of a button which save the modification of the datagrid
MySqlDataAdapter1.Update(DataSet11)
Thank your very much
mysqldirect can't update MYSQL's data
Re: mysqldirect can't update MYSQL's data
Please check that valid InsertCommand, UpdateCommand and DeleteCommand
are set for your DataAdapter component. Or you can use MySqlCommandBuilder
component for automatic generating update commands.
See DataSet demo project for a sample of working with DataSet.
are set for your DataAdapter component. Or you can use MySqlCommandBuilder
component for automatic generating update commands.
See DataSet demo project for a sample of working with DataSet.