Hwo to read XML file using C#,

Question

0.00/5 (No votes)

See more:

I have xml file structure like,

XML

<?xml version="1.0" encoding="utf-16"?>
<root>
  <path>C:\Users\bsushil\Documents\Sharpdesk Desktop\New folder</path>
  <path>C:\Users\bsushil\Documents\Sharpdesk Desktop\New folder (1)</path>
  <path>C:\Users\bsushil\Documents\Sharpdesk Desktop\New folder (2)</path>
</root>

How do i retrieve the Path value.

What I have tried:

C#

XDocument xdoc = XDocument.Load(@"D:\Sushil\Information.xml");

           var servers = xdoc.Descendants("root");
           for (var server in servers)

Posted 8-Feb-18 20:23pm

Member 11859517

Updated 8-Feb-18 20:27pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2018-02-08T20:27:00

Solution 1

You're on the right track:

C#

XDocument xdoc = XDocument.Load(@"D:\Sushil\Information.xml");
var paths = xdoc.Descendants("path").Select(x=>x.Value).ToList();
for (var p in paths)
{
    Console.WriteLine("{0}", p);
}

Posted 8-Feb-18 20:27pm

Maciej Los

Updated 8-Feb-18 20:29pm

v2

Comments

Member 11859517 16-Feb-18 8:32am

Thanks Maciej,

I got the path, now i am checking whether the directory is exist or not, if not exist then immediately I have to remove that node from xml file, how can we do this?

Maciej Los 17-Feb-18 8:49am

You're very welcome.
Check this: XNode.Remove Method ()

Member 11859517 20-Feb-18 23:56pm

Thanks Maciej Los,
I am not able to delete from the xml file, You gave solution for getting the path

var paths = xdoc.Descendants("path").Select(x=>x.Value).ToList();
for (var p in paths)
{
if(!Directory.Exist(p)
{
remove from the xml????? how can I do this,
}
}

Maciej Los 21-Feb-18 2:02am

p.Remove();

Member 11859517 21-Feb-18 4:16am

Getting this error,
Error 104 The type 'char' cannot be used as type parameter 'T' in the generic type or method
'System.Xml.Linq.Extensions.Remove<t>(System.Collections.Generic.IEnumerable<t>)'.
There is no boxing conversion from 'char' to 'System.Xml.Linq.XNode'.

Maciej Los 21-Feb-18 4:56am

Because, you need to return XNode, instead of text. Change:

var paths = xdoc.Descendants("path").Select(x=>x.Value).ToList();

to:

var paths = xdoc.Descendants("path").Select(x=>x).ToList();

Member 11859517 21-Feb-18 6:55am

This will remove from where? because its not removed from xml file. i need when path.value not exist, the remove from the .xml file. how can I update the xml file so that file will contains only available items.
thanks.

Maciej Los 21-Feb-18 7:13am

OMG! Are you trying to solve your issue by yourself or you do expect that i'll resolve all your issues?

XDocument xdoc = XDocument.Load(@"D:\Sushil\Information.xml");
var paths = xdoc.Descendants("path").ToList();

for(int i=0;i<paths.Count;i++)
{
	if(!Directory.Exists(paths[i].Value)) paths[i].Remove();
}

Member 11859517 1-Mar-18 4:23am

Thank you Maciej Los.
<root>
<folder>
<path>C:\Users\bsushil\Documents\Sharpdesk Desktop\Tinki
<name>Tinkiiiii

<folder>
<path>C:\Users\bsushil\Documents\Sharpdesk Desktop\Tinki\New folder
<name>New folder

<folder>
<path>C:\Users\bsushil\Documents\Sharpdesk Desktop\Tinki\New folder (1)
<name>New folder (1)

How can i retrieve this into dictionary<string, string>.

Maciej Los 1-Mar-18 4:56am

You should post it as new question...
Let me know, when you finish.
[EDIT]
By The Way: your xml is not well formed. I do not see ending tag for name.

Member 11859517 1-Mar-18 5:41am

Ending tag is there but when I pasted its not coming, by the way I got the answer,
Thank you for your great help.

Maciej Los 1-Mar-18 5:54am

You're very welcome.

Member 11859517 1-Mar-18 5:45am

here is my solution.
foreach(XElement xe in xdoc.Descendants("Folder"))
{
dictionary.Add(xe.Element("name").Value),xe.Element("path").Value);
}

Maciej Los 1-Mar-18 5:54am

Good job!