C# - Convert XML elements to key value pair in a concatenated string

Question

I Have below XML as an input


  
    xyz
    no
  
  
    
      
        aaaa
        zzzz
      
      
        bbbb
        yyyy
      
      
        cccc
        xxxx

Desired output :

String strOutput = "|Participant1FirstName = aaaa|Participant1LastName = zzzz|; |Participant2FirstName = bbbb|Participant2LastName = yyyy|; |Participant3FirstName = cccc|Participant3LastName = xxxx|"

SO far, I have tried parsing XML string into XDocument, and thinking of using Linq to get the desired output, but don't know the way forward.

Input :

string strXML = "      xyz    no                      aaaa        zzzz                    bbbb        yyyy                    cccc        xxxx            "
            
XDocument xdoc = new XDocument();
xdoc = XDocument.Parse(strXML);

Edit

Any way I can get desired output from below XML ?

user_5836671 · Answer

You could do it like this

XDocument xdoc = new XDocument();
xdoc = XDocument.Parse(strXML);

var values = xdoc.Descendants("Participant").Elements()
                 .Select(x => x.Name + " = " + x.Value).ToList();

 string result = string.Join("|", values);

user_5015238 · Answer

Try following :

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Xml;
using System.Xml.Linq;

namespace ConsoleApplication1
{
    class Program
    {
        const string FILENAME = @"c:	emp	est.xml";
        static void Main(string[] args)
        {
            XDocument doc = XDocument.Load(FILENAME);

            List participants = doc.Descendants("Participant").Select(x => new Particapant()
            {
                firstName = (string)x.Elements().FirstOrDefault(),
                lastName = (string)x.Elements().LastOrDefault()
            }).ToList();

            string output = string.Join(";", participants
                .Select(x => string.Format("|ParticipantFirstName = {0}|ParticipantLastName = {1}|", x.firstName, x.lastName)));
        }
    }
    public class Particapant
    {
        public string firstName { get; set; }
        public string lastName { get; set; }
    }
}

C# - Convert XML elements to key value pair in a concatenated string

2 Answers