mysqldirect can't update MYSQL's data

mysqldirect can't update MYSQL's data

Postby Peter » Sat 06 Nov 2004 17:49

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
Peter
 

Re: mysqldirect can't update MYSQL's data

Postby Oleg » Tue 09 Nov 2004 10:47

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.
Oleg
Devart Team
 
Posts: 264
Joined: Thu 28 Oct 2004 13:56


Return to dotConnect for MySQL