Multiple Updates of the same DataSet

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
nuntio2000
Posts: 19
Joined: Fri 19 Nov 2004 18:51
Location: South Italy

Multiple Updates of the same DataSet

Post by nuntio2000 » Sat 20 Nov 2004 13:11

Hi,
I'm using your procedure CopyDataSet to insert new data in the database. I've left the PK of my Dataset setted to NULL and the MySQLDirect performs a perfect update process.
Well, but how can i avoid multiple update of the same data?
The remote Database is very big, so i think that to fill a local dataset and
use Data.Merge to find the diff could be really hard.
Do you have some idea to help me?

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

Re: Multiple Updates of the same DataSet

Post by Oleg » Mon 22 Nov 2004 11:16

You can fill your key field values as it was described in topic How do I retrieve an Auto Increment Primary Key after Insert

Post Reply