Controlling the order data is saved in a DataSet

Posted on 2013-06-28
Medium Priority
Last Modified: 2013-07-04
I've got a number of tables in my DataSet, but I can't seem to control the order they are saved in, and sometimes this results in foreign key errors.

There are lots of useful tips about using DataSets - for example here:


but I can't find how to ensure one table is saved first to fix this problem. Can anyone point me in the right direction here?
Question by:purplesoup
LVL 40

Accepted Solution

Jacques Bourgeois (James Burger) earned 2000 total points
ID: 39285238
Do not Update the DataSet. Update the individual tables, in the proper order. The mechanism for tables is the same as for a DataSet.

Author Comment

ID: 39299367
ok thanks - well it turns out after some investigation that with foreign keys we had code to check the relations between the tables and update consistently, but somehow bad data was getting into the DataSet which lost the relations - so yes, the answer is to update the tables individually in the proper order.

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question