Get value from xml file

darma teja

12y1.6kVisual Basic .NET

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

11 Replies

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

Vulpes12y ago
Accepted 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("\r\n", lines.Skip(1).Take(4)));
XElement Data = XElement.Parse(String.Join("\r\n", lines.Skip(5)));
string mainlang = information.Elements("information1").Where( i1 => i1.Attribute("name").Value == "mainlang").First().Value;
Console.WriteLine("mainlang = {0}\n", mainlang);

foreach(XElement dataname in Data.Elements("dataname"))
{
Console.WriteLine("dataname = {0}", dataname.Value.Replace("\n", ""));
Console.WriteLine("lang = {0}", dataname.Attribute("lang").Value);
Console.WriteLine("group = {0}\n", 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
darma teja12y ago
Thanks allot Vulpes!
Abhishek Kumar12y ago
Modify you xml you need to add root in your xml dear.

Abhishek
darma teja12y ago
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] + "\n\t" + "" + fragments.Replace(z[0], "") + "\n\t" + "";

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 teja12y ago
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 Kumar12y ago
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 teja12y ago
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 Kumar12y ago
Hi,

if your xml file would be as below

xml version="1.0" encoding="utf-8" standalone="yes"?>

<informations>

<information>

<information1 name="region">Asiainformation1>

<information1 name="mainlang">ENGinformation1>

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
Abhishek Kumar12y ago
Ok let me try with some modification.

Abhishek
darma teja12y ago
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 Kumar12y ago
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