Only getting the first value while parsing an XML document using Linq

Question

My XML file:

From this XML I want to calculate the remaining sessions for each course and for each instructor (considering that each course has 15 sessions). So first I wanted to get the number of sessions of each instructor for the first course (AGL). My problem is I can only get the first session which its numberOfsessions is equal to 1.

With this c# code:

var xDoc = XDocument.Load(@"C:\Users\Gaby\Desktop\a.xml");

var homePhone = from phoneno in xDoc.Root.Element("tracking").Elements("course")
                where phoneno.Attribute("name").Value.Equals("AGL")
                select phoneno;

foreach (XElement xEle in homePhone)
{
    Console.WriteLine(xEle.Element("instructor").Element("session").Attribute("numberOfsessions").Value);
}

I tried getting instructors names of each course ( like "AGL" should get me "Youssef" and "Maroun" but it only got me "Youssef"(the first xml element). I even tried to replace the var homePhone with a IEnumerable homePhone but I got a null pointer while parsing it into a list.

And I also have another problem , I want to insert new sessions for every instructor in my xml file using Linq and c#, so is there any way I can edit existing XElements or should I create a new XElement every time?

Thank you for your time.

jdweng · Accepted Answer

Try following :

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

namespace ConsoleApplication1
{
    class Program
    {
        const string FILENAME = @"c:	emp	est.xml";
        static void Main(string[] args)
        {
            XDocument xDoc = XDocument.Load(FILENAME);
            List homePhone = (from phoneno in xDoc.Descendants("course")
                            where (string)phoneno.Attribute("name") == ("AGL")
                            select phoneno).ToList();

            foreach (XElement instructor in homePhone.Elements("instructor"))
            {
                foreach (XElement session in instructor.Elements("session"))
                {
                    Console.WriteLine("id = '{0}', name = '{1}', credits = '{2}', date = '{3}', number of sessions = '{4}'",
                        (string)instructor.Attribute("id"),
                        (string)instructor.Attribute("name"),
                        (string)instructor.Attribute("nbrecredits"),
                        (string)session.Attribute("date"),
                        (string)session.Attribute("numberOfsessions")
                        );
                }
            }
        }

    }


}

Only getting the first value while parsing an XML document using Linq

Answers (2)

Related Questions