Update fail

Update fail

Postby jmcv » Tue 01 Feb 2011 14:27

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.
jmcv
 
Posts: 1
Joined: Tue 01 Feb 2011 14:04
Location: South Carolina

Postby 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/docs/?DataTable.html.
The Dataset Wizard documentation is here: http://www.devart.com/dotconnect/mysql/docs/?DataSets.html.
Shalex
Devart Team
 
Posts: 7475
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL