Update Data in a DataSat from an XML-File

[adrian]

Hil all

Following Problem:
I want to update data in an oracle database from an xml file. That
means the operation should perform an insert or update on the data in
the database if either the data in the xml is new or different from
the one in the database.

For this i have read the article 'Synchronizing a DataSet with an
XmlDataDocument' in the Visual Studio .NET 2003 combined collection.
But I think there is not written what I need? Because this article
describes how to synchronize a XMLDataDocument with an DataSet or
DataSet with a XMLDataDocument but it does not describe how to update
the data in the dataSet.

Thank you for your help.
Adrian

 

[Guest]

The XMLDataDocument does not update a database. It only provides multiple
views of in-memory data to your application. As you no doubt learned from
the article you read, one view is an XML view and the other view is termed a
DataSet, which provides what we could think of a relational view of the same
data in that it has rows and columns and tables that can have primary keys,
foreign keys, and some of the things associated with relational databases.

But the dataset is not, by itself, linked to any database. Such linkage is
provided by a DataAdapter (specifically OleDbDataAdapter, SQLDataAdapter,
OracleAdapter, possiblty some others). The DataAdapter contains mapping
between a database table, rows, and columns of a database and the rows,
columns and a table in your dataset. It also holds references to command
objects that tell it precisely how to perform updates to the database, using
the data in the DataSet.

So, DataAdapters would be a good thing to do some further reading on, along
with command objects, etc.

Good Luck