Update fail

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Posts: 1
Joined: Tue 01 Feb 2011 14:04
Location: South Carolina

Update fail

Post by jmcv » Tue 01 Feb 2011 14:27

I'm building a small DB app with .net 2008 and MyDirect .Net Professional Edition vs.

I am having no trouble selecting the data and displaying it in the program.

Private Sub vbname(form objvar, e) Handles vbname.click
End sub

But I can't send updates to the MySql Database. I set everything up using the DataSet Manager and automatically generating the update, insert, and delete commands, but I don't understand how to call them appropriately.

Site Admin
Posts: 8239
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 02 Feb 2011 17:16

If the update, insert, and delete commands of your MySqlTableAdapter are already generated, modify your MySqlDataSet (its tables) and call DataSet.Update() that executes the appropriate commands to delete, insert, or update rows into the database.
If you encounter any difficulties, please specify the problem (the error text or description of incorrect behaviour) send us a small test project with the corresponding DDL/DML script.

MySqlDataSet is based on the advanced features of MySqlDataTable: http://www.devart.com/dotconnect/mysql/ ... Table.html.
The Dataset Wizard documentation is here: http://www.devart.com/dotconnect/mysql/ ... aSets.html.

Post Reply