Help with adding data elements in string variable using VB.NET

Hi,

How do you modify the code below to add data elements from a string variable (i.e. S = Effect, NSC, NSN, AGD)?

Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
         Dim xdoc As XDocument = XDocument.Load(Application.StartupPath + "\AOP5.xml")
         Dim results = (From n In xdoc.Root.Descendants("AOP5")
                        Select n).ToList()
         Dim resultsa = (From n In xdoc.Root.Descendants("Effect")
                     Select n).Count()

         If resultsa = 0 Then
         results.ForEach(Sub(n) n.Add(<Effect></Effect>))
         End If

         xdoc.Save(Application.StartupPath + "\AOP5.xml")

Open in new window

Thanks,

Victor

Well you could do it this way:

        Dim results = (From n In xdoc.Root.Descendants("AOP5")
                       Select n).ToList()

        Dim S As String = "Effect, NSC, NSN, AGD"
        For Each sElem As String In S.Split({","c, " "c}, StringSplitOptions.RemoveEmptyEntries)
            Dim resultsa = (From n In xdoc.Root.Descendants(sElem)
                        Select n).Count()
            If resultsa = 0 Then
                Dim newElem As String = sElem ' copy for use in lamba expression as per warning given by the compiler/IDE
                results.ForEach(Sub(n) n.Add(New XElement(newElem)))
            End If
        Next

Open in new window

However, judging from your other open question, you may be wanting to add each of them if not present in a subnode instead of what the code does now: add each new element if it is not present anywhere in the document. If that's the case, try the following:

        Dim results = (From n In xdoc.Root.Descendants("AOP5")
                       Select n).ToList()

        Dim S As String = "Effect, NSC, NSN, AGD"
        For Each sElem As String In S.Split({","c, " "c}, StringSplitOptions.RemoveEmptyEntries)
            Dim newElem As String = sElem ' copy for use in lamba expression as per warning given by the compiler/IDE
            results.ForEach(Sub(n) If n.Descendants(newElem).Count = 0 Then n.Add(New XElement(newElem)))
        Next

Open in new window

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

vcharlesAuthor Commented: 2015-09-04

Help.

LVL 35

Robert SchuttSoftware EngineerCommented: 2015-09-04

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial

Hi,

It worked. Thank You.

How do you modify the code to remove all Data elements in File1 not found in a string variable S = "Effect, NSC, NSN, AGD"?

Victor

Thank You!

How do you modify the code to remove all Data elements in File1 ...

Which one did you choose?

Can you give an example input file?

EDIT: and output file?

I chose the second one, better incase dataelment already exist.

Thanks,

Victor

Help with adding data elements in string variable using VB.NET

Who is Participating?