I'm building a small DB app with .net 2008 and MyDirect .Net Professional Edition vs. 4.85.34.0.
I am having no trouble selecting the data and displaying it in the program.
Private Sub vbname(form objvar, e) Handles vbname.click
Me.Argd_grantsTableAdapter.Fill(Me.Ds.argd_grants)
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.
Update fail
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.
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.