Reading Xml using Dom Approach and storing it in Dictionary

Jay Kamble

I have this Following XML File:

And I have written this program using DOM to read and store the data into dictionary. But, while printing I am not getting any output. The console remains Blank.

The code is below:

Dictionary dictionary = new Dictionary();

XmlDocument document = new XmlDocument();

document.Load("Employee.xml");

XmlNodeList node1 = document.GetElementsByTagName("Dept Name");

foreach (var item in node1)

{

XmlNodeList node2 = document.GetElementsByTagName("//Emps/Emp");

foreach (var item1 in node2)

{ dictionary.Add(item.ToString(),Convert.ToInt32(item1.ToString()));

}

foreach (var item in dictionary)

{

Console.WriteLine("Key= " + item.Key + "\nValues= " + item.Value );

}

Console.ReadLine();

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Munták István9y ago
Accepted answer
There are more problems with your approaching. The first one is you try to put more items with the same keys into the Dictionary. The Key field of the dictinoray has to be uniqe. The second problem is you can't get the proper values by this solution.

So try to do this way:
XmlNodeList node1 = document.GetElementsByTagName("Dept");
            foreach (XmlNode item in node1)
            {
                var name = item.Attributes[0].Value;
                XmlNodeList node2 = item.ChildNodes[0].ChildNodes;
                List<int> values = new List<int>();
                foreach (XmlNode item1 in node2)
                {
                    values.Add(Convert.ToInt32(item1.InnerText));
                }
                dictionary.Add(name, values);
            }

            foreach (var item in dictionary)
            {
                Console.Write("Key="+item.Key);
                Console.Write("\nValues=");
                foreach (var valueItem in item.Value)
                {
                    Console.Write(valueItem + " ");
                }
                Console.WriteLine();
            }
            Console.ReadLine();
+2
Jay Kamble9y ago
Thank you again Munták István. I will be more observant from next time.
0
Munták István9y ago
Yes, because you have to declare the Directory 1-n structure instead of 1-1. You have to pay attention we fill a List and not an int.
Dictionary<string, List<int>> dictionary = new Dictionary<string, List<int>>();
0
Jay Kamble9y ago
Thank You Munták István. The solution you gave is really helpful. The basic problem was with the Tag name which is "Dept" only and not "Dept Name" as Name is the attribute there. But now I am getting an error while inserting the data into Dictionary.

"dictionary.Add(name, values);" Here in this line saying Invalid Arguments.

I have attached a snapshot of it as well.
0