UPDATE a table from XML file

Hot Topic

silent unpack of
Task complete DateTime
complex SQL (for me) step 2
Help W/Disabling FK Constraints for Batch Operations
Beginner question Searching table
Identify/parse content within binary documents?
replication; what is: SqlCeReplication.Subscriber?
In which language is JDBC Driver written
What do you miss on SSIS?
Creating a double entry book keeping system

SQL Server

Add a column to a table.
Server goes slow roughly every 24 hours
Scripting: Dumb Q.. How can I store a DTS variable inside a script variable?
Am I missing something when trying to connect via ASP.NET 2.0??
First or last row in T-SQL
DtsConnection -- Consuming DTS DataReader In Code w/ Parameters
Watermark Generation is Invalid Error
How do I drop sql server mobile database when ...?
Cannot access Calculations tab, BI Studio hangs up after installing SP1 and Hot fix.
How to remove unused columns and eliminate warnings

UPDATE a table from XML file

I have a winforms app which has to update a database from a XML file.
I receive an XML file by mail and then I have to update a some records from a SQL database.
Which is the best approach to do this


Answer this question

UPDATE a table from XML file

  • learningdba

    Can you provide a bit more context   Your question is very general.  Are you trying to insert the entire XML instance into the database   Does the XML represent some kind of "update" that you have to apply to data which is already in the database

  • nathan phillips

    Look into the classes in System.Xml for querying/parsing the XML file.  Once you have the information you need, you can use the classes under System.Data to perform the database operations.
  • UPDATE a table from XML file
Answer this question