Reading XML using C#

Question

<Tasks>
    <AuxFiles>
        <FileType AttachmentType='csv' FileFormat ='*.csv'>
    </AuxFiles>
</Tasks>

What is the syntax in C# to get the FileFormat if I know the AttachmentType?

Any and all help is always appreciated.

Is your question: Given this xml file I want to find the Fileformat attribute value for a given AttachtmentType ? So you want to find "*.csv" when you look for "csv" ? — Eddy
– Eddy, Commented Aug 9, 2011 at 19:30

Jon Skeet · Accepted Answer · 2011-08-09 19:28:45Z

5

I'd use LINQ to XML:

var doc = XDocument.Load("file.xml");

var format = doc.Descendants("FileType")
                .Where(x => (string) x.Attribute("AttachmentType") == type)
                .Select(x => (string) x.Attribute("FileFormat"))
                .FirstOrDefault();

This will give null if there is no matching element or if the first FileType with a matching AttachmentType doesn't have a FileFormat attribute.

answered Aug 9, 2011 at 19:28

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

carlosfigueira · Accepted Answer · 2011-08-09 19:27:36Z

2

You can use XElement and the query support for that.

        XElement element = XElement.Parse(@"<Tasks>
  <AuxFiles>
    <FileType AttachmentType='csv' FileFormat ='*.csv' />
  </AuxFiles>
</Tasks>");
        string format = element.Descendants("FileType")
            .Where(x => x.Attribute("AttachmentType").Value == "csv")
            .Select(x => x.Attribute("FileFormat").Value)
            .First();

        Console.WriteLine(format);

answered Aug 9, 2011 at 19:27

carlosfigueira

87.7k14 gold badges137 silver badges176 bronze badges

1 Comment

carlosfigueira Over a year ago

Jon Skeet's solution is more robust than this one, since it won't cause a NullReferenceException if there are no types matching or if the element doesn't have a FileFormat attribute. But the idea is the same.

Crandel · Accepted Answer · 2011-09-07 18:19:11Z

1

Try this code:

string fileFormat = string.Empty;


XmlDocument xDoc = new XmlDocument();
xDoc.Load(fileName);

XmlNodeList auxFilesList = xDoc.GetElementsByTagName("AuxFiles");
for (int i = 0; i < auxFilesList.Count; i++)
{
   XmlNode item = classList.Item(i);
   if (item.Attributes["AttachmentType"].Value == "csv")
   {
      fileFormat = item.Attributes["FileFormat"].Value;
   }
}

edited Sep 7, 2011 at 18:19

answered Aug 9, 2011 at 19:31

Crandel

1,0078 silver badges10 bronze badges

Comments

NirMH · Accepted Answer · 2011-08-09 19:29:20Z

0

You can use XPATH to query any element in your XML file.

see this ULR: http://www.whitebeam.org/library/guide/TechNotes/xpathtestbed.rhtm

check also this SO post: "How to query a peer XMLNode .NET"

answered Aug 9, 2011 at 19:29

NirMH

5,0254 gold badges53 silver badges77 bronze badges

Comments

Tanvir · Accepted Answer · 2013-09-17 16:12:54Z

0

Another way of doing it is:

XmlDocument xDoc = new XmlDocument();
xDoc.Load("path\\to\\file.xml");

// Select the node where AttachmentType='csv'
XmlNode node = xDoc.SelectSingleNode("/Tasks/AuxFiles/FileType[@AttachmentType='csv']");
// Read the value of the Attribute 'FileFormat'
var fileFormat = node.Attributes["FileFormat"].Value;

answered Sep 17, 2013 at 16:12

Tanvir

1,5222 gold badges17 silver badges32 bronze badges

Collectives™ on Stack Overflow

Reading XML using C#

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related