Help with updating/adding data elements from fileB to fileA

How familiar are you with reading and writing XML documents?

You should just be able to query the one file for the LinkAID element and set its value based on the value you read from FileA - or append if not found.

Before writing any code - best to first understand the basics - so let us know what your level is and post any code you have attempted with this and lets take it from there.

Hi,

I know how to add data to an xml file but I need help with comparing values of an xml file with another xml file and then either add or replace values. Below is an example of saving data selected from a Grid to an xml file.

Dim MyDocLinkSSADB As XDocument = XDocument.Load(Application.StartupPath + "\LinkSSADB.xml")

            Dim LinkID = (From el In MyDocLinkSSADB.Descendants("LinkA") Select Int(el.<LinkAID>.Value)).ToList
            LinkID.Sort()
            Dim xNewLink As XElement = New XElement("LinkA")
            xNewLink.Add(New XElement("LinkAID", (LinkID.Last() + 1)))




            MyDocLinkSSADB.Root.Add(New XElement("LinkA", New XElement("LinkAID", (LinkID.Last() + 1)), New XElement("Order_ID", ComboBox1.SelectedIndex), New XElement("Problem_ID", SearchIdProblemeID), New XElement("POC_ID", POCid), New XElement("POC_ID", POC2id)))
            MyDocLinkSSADB.Save(Application.StartupPath + "\LinkSSADB.xml")

Thanks,


Victor

Hi,

Thanks for the link, but I still can't figure the code to solve this issue, can you please send me an example.

Thanks,

Victor

It will have to wait until next week - I am away until then - you can either request attention for a notification to be sent out to additional experts or hang on until next week.

OK, I will request attention for but would appreciate your help next week if this issue is not resolved. Thanks for your feedback.