Odpovědět UPDATE a table from XML file

  • martes, 23 de agosto de 2005 9:40
     
     
    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 ?

Todas las respuestas

  • miércoles, 24 de agosto de 2005 18:01
     
     
    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?
  • lunes, 29 de agosto de 2005 17:16
     
     Respondida
    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.