Update command problem

[anubis7000]

Hi,

I am using visual studio 2005 to build a form that is connected to a mysql backend.

I am able to bind datagrids and text boxes to the database, however, if I add a new record in the form, the data is not saved.

I have read that I can use the dataadapter.update method to save changes, however, I get an error stating that the update method is not supported.

When I use the tableadapter configuration wizard, I am unable to select the “refresh data table” under advanced options under “Enter an SQL statement” or select “create methods to send updates directly to database” under “choose methods to generate” and under ”wizard results” update and delete methods are not displayed.

Also, if I try to set the “generatedbdirectmethods” to true I get an error message.

Is this an ODBC driver issue? thnx

 

[tag141]

I followed this tutorial when I had problems creating update, save, insert etc buttons. If I can follow it then any one can follow it. Talks about connections as well.

http://www.homeandlearn.co.uk/NET/nets12p1.html