Not sure if this is the right newsgroup but ..
I have a DataSet and write the tables to xml files.
Now some of these tables have an Autoinc field as PK, but due to
deletions etc, they do not start at 1 and there are gaps.
When I read these files into an empty dataset, the rows are marked as
'Added' and when I update the ds, the id's start again at 1+.
This craps out links to other tables.
Is there a way of telling the dataset not to use the autoinc ?