Update database using DataAdapter for DataSet populated from XML file?

Hi,

I have an XML file with data which I am reading into a dataset. I want to make changes to a table in my database based on values from the dataset. These changes can include updates, inserts and deletes.

I would like to use a DataAdapter (odbc) to do the update.

However, my dataset was not filled using the DataAdapter... how can I make use of the DataAdapter to update the datasource in this scenario?


Regards,
Frode
.

Relevant Pages

  • Re: Some newbie questions
    ... datatabase you can use as well the executescalar, for reading sequential by ... > dataadapter for each table and then create a dataset that includes each of ... one and replace everytime the selectcommand, the insertcommand, the ... Should you link tables in the database using views/queries in the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL JOB Write to a File
    ... Reading a file and doing ... Inserts and Updates to the Database? ...
    (microsoft.public.sqlserver.server)
  • Re: how to move location of default database???? plz!
    ... fine, cool about the database, it probably amounts to how much tagging one ... updates - i woulda rolled them all back. ... No recent version of Windows does ... well when you have less than about 50MB to 100MB of free space. ...
    (microsoft.public.windowsmedia.player)
  • Re: Update Sql Server 2000 database from the HP3000
    ... collects those updates via ODBC every 10 or so seconds. ... essentially update the SQL database at the same time as the main ... Authorised and regulated by the Financial Services Authority. ...
    (comp.sys.hp.mpe)
  • Re: The right database for the job?
    ... Note that "many updates ... > the programmer that have to fix somebody elses code and/or database ... > devices under its control, it connects to a central "DB server" program ...
    (comp.databases)