Get value from xml file

Question

Hi All I have a xml file like this: Asia ENG test1.xml test2.xml test3.xml test4.xml I am trying to get information/information1['mainlang'] == ENG from xml file. and also I would like to get All lang group dataname from xml file. I am getting following error invalid data at the root level. line 1 position the first for the following code: XDocument doc = XDocument.Load(path); XElement test = doc.Root; var nodeList = doc.SelectNodes(//dataname); Advance thanks Darma

Vulpes · Answer

Rather than adding a 'single' root another way to approach this would be to treat the file as two XML files like this: using System; using System.IO; using System.Linq; using System.Xml.Linq; class Program { static void Main() { string path = whatever.xml; string[] lines = File.ReadAllLines(path); XElement information = XElement.Parse(String.Join(
 lines.Skip(1).Take(4))); XElement Data = XElement.Parse(String.Join(
 lines.Skip(5))); string mainlang = information.Elements(information1).Where( i1 => i1.Attribute(name).Value == mainlang).First().Value; Console.WriteLine(mainlang = {0}
 mainlang); foreach(XElement dataname in Data.Elements(dataname)) { Console.WriteLine(dataname = {0} dataname.Value.Replace(
 )); Console.WriteLine(lang = {0} dataname.Attribute(lang).Value); Console.WriteLine(group = {0}
 dataname.Attribute(group).Value); } Console.ReadKey(); } } The output is: mainlang = ENG dataname = test1.xml lang = Hindi group = Asia dataname = test2.xml lang = Chinese group = Asia dataname = test3.xml lang = English group = US dataname = test4.xml lang = Polish group = EU

Abhishek Singh · Answer

Hi if your xml file would be as below xml version =  1.0  encoding =  utf-8  standalone =  yes  ?> informations > information > information1 name =  region  > Asia information1 > information1 name =  mainlang  > ENG information1 > information > Data > dataname lang =  Hindi  group =  Asia  > test1.xml dataname > dataname lang =  Chinese  group =  Asia  > test2.xml dataname > dataname lang =  English  group =  US  > test3.xml dataname > dataname lang =  Polish  group =  EU  > test4.xml dataname > Data > informations > i have added a root information. Please try this code below.. XmlDocument doc = new XmlDocument (); doc.Load( @D:\My Development\TestWeb\TestWeb\Test.xml ); // Root element System.Xml. XmlElement root = doc.DocumentElement; System.Xml. XmlElement information = (System.Xml. XmlElement )root.ChildNodes[0].ChildNodes[0]; string information1 = information.ChildNodes[0].InnerText; if (information1 == ENG ) { //Put your logic here } Hope this will help. Abhsihek

darma teja · Answer

Thanks allot Vulpes!

Abhishek Singh · Answer

Modify you xml you need to add root in your xml dear. Abhishek

darma teja · Answer

Got the solution! I would like to know is there any easy and fast solution for this. My code is like this: string fragments = File.ReadAllText(xmlFilePath); string[] z = File.ReadLines(xmlFilePath).Take(1).ToArray(); var myRootedXml = z[0] + 
	 +   + fragments.Replace(z[0] ) + 
	 +  ; XmlDocument xml = new XmlDocument(); xml.LoadXml(myRootedXml); XmlNodeList xnList = xml.SelectNodes(Root/Data/Dataname); foreach (XmlNode xn in xnList) { string Dataname = xn.InnerText; string lang = xn.Attributes[lang].Value; string group = xn.Attributes[group].Value } Thanks Darma

darma teja · Answer

I gave my xml file path only there is no exception for path it is giving me exception  There are multiple root elements present. Line 8 position the second.  It means that two root elements present in the xml file. Thanks Darma

Abhishek Singh · Answer

Dharma D:\My Development\TestWeb\TestWeb\Test.xml This is my local machine test location for test file  you need to provide the your path where your xml file is residing. Abhishek

darma teja · Answer

Hi Abhishek I am getting exception exactly at: doc.Load( @D:\My Development\TestWeb\TestWeb\Test.xml ); The exception is There are multiple root elements present. Line 8 position the second. and I would like to get the output Hindi-Asia-test1.xml Chinese-Asia-test2.xml English-us-test3.xml Polish-EU-test4.xml Thanks Darma

Abhishek Singh · Answer

Ok let me try with some modification. Abhishek

darma teja · Answer

Hi Abhishek Thanks for the message. Actually It is multiple root level element xml file. I cannot change this xml file because i get it from customer. I think we can artificially add a root to this xml file is it works? Thanks Darma

Abhishek Singh · Answer

Darma Your Xml file seems to have issue as it has multiple root level element. Could you please verify and provide the proper xml.? Abhishek