mysqldirect can't update MYSQL's data

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Peter

mysqldirect can't update MYSQL's data

Post by 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

Oleg
Devart Team
Posts: 264
Joined: Thu 28 Oct 2004 13:56

Re: mysqldirect can't update MYSQL's data

Post by 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.

Post Reply