So Let’s start with post with a very often situation in our coding life.
Generally we used Data Set for having the collection of Data.
For more information, see Suspending Update Constraints.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.
You can manipulate the collection directly to delete records.
However, if you want to send changes to the database or to another process, the dataset has to maintain change information for deleted rows.
However, you can also use different adapters, for example, to move data from one data source to another or to update multiple data sources.
After your dataset is populated with data, you will typically perform some kind of manipulation of the data before sending it back to the data source or to another process or application.
I pass data between Website and Web Service with Data Sets.
Now I want to be able to update the data base with changes made in the user interface of the Website.
For more information, see Windows Forms Data Architecture.
If the dataset includes constraints, you can temporarily turn constraints off before making any updates, and then turn them back on afterward.