LINQ to XML parse Attribute Values

In this post LINQ to XML parse Attribute Values, we shall see how to parse the values of Attributes from XML tags. In the post LINQ to XML parse XML Elements, we saw how to extract values from specific elements, here we shall see on how to extract the values associated with the attributes of the elements.

Assume that we have the following XML fragment

   <Employees>

 <Employee>

<Name>

<FirstName>Henry</FirstName>

<LastName>Ford</LastName>

  </Name>

<Age>65</Age>

<Department Name="Automobile" />

  </Employee>

  <Employee>

<Name>

<FirstName>Bill</FirstName>

<LastName>Gates</LastName>

</Name>

<Age>55</Age>
<Department Name="Software" />

  </Employee>

  </Employees>

  Now we will parse the XML and get the values of the Name attribute in the Department Tag.

XElement xEmp = XElement.Load(@"D:\Employees.xml");

var empNames = from emps in xEmp.Elements("Employee")

               select emps;

foreach (XElement empDetails in empNames)

{

    Response.Write("Name: " +  empDetails.Element("Name").Element("FirstName").Value + "</br>");

    Response.Write("Age: " + empDetails.Element("Age").Value + "</br>");

    Response.Write("Department: " + empDetails.Element("Department").Attribute("Name").Value + "</br></br>");

} 

  When this code is executed, the output will be

  

Name: Henry
Age: 65
Department: Automobile

Name: Bill
Age: 55
Department: Software

  That’s it we have parsed an XML fragment using LINQ to XML and extracted the attribute values for the attributes associated with the Element tags. 

Related Post

LINQ to XML Overview

LINQ to XML Classes Overview

XDocument Examples

XElement Example

XAttribute Example

LINQ to XML parse XML Elements

LINQ to XML parse Child Elements

LINQ to XML parse Attribute Values

LINQ to XML - Count Elements

LINQ to XML Filter on Element Values

LINQ to XML Filter on Attribute Values

LINQ to XML Add new Elements

LINQ to XML Update Element Values

LINQ to XML Update Attribute Values

LINQ to XML Delete Attributes

LINQ to XML Delete Elements

LINQ to XML Add Attributes

LINQ to XML parse Child Elements

In this post LINQ to XML parse Child Elements, we shall see how to parse the values of Child elements from the XML. In the post LINQ to XML parse XML Elements, we saw how to extract values from specific elements, here we shall see on how to extract the values from the subsequent Child elements.

Assume that we have the following XML fragment

   <Employees>

 <Employee>

<Name>

       <FirstName>Henry</FirstName>

       <LastName>Ford</LastName>

</Name>

<Age>65</Age>

  </Employee>

  <Employee>

<Name>

    <FirstName>Bill</FirstName>

    <LastName>Gates</LastName>

</Name>

<Age>55</Age>

  </Employee>

  </Employees>

  Now we will parse the XML and get the Name & Age of all the Employees from the XML, using the following code.

XElement xEmp = XElement.Load(@"D:\Employees.xml");

var empNames = from emps in xEmp.Elements("Employee")

               select emps;

foreach (XElement empDetails in empNames)

{

    Response.Write("Name: " +
    empDetails.Element("Name").Element("FirstName").Value + "</br>");

    Response.Write("Age: " + empDetails.Element("Age").Value + "</br></br>");

}  

  When this code is executed, the output will be

  

Name: Henry
Age: 65

Name: Bill
Age: 55

Notice that the LINQ query is filtering only for the elements with name Employee, but we have iterated through the First level child node Age and extracted the values of the child elements, in the line.

empDetails.Element("Age").Value

We have also iterated through the 2nd level Name -> FirstName child elements and extracted the values of the child elements, in the line.

empDetails.Element("Name").Element("FirstName").Value

  That’s it we have parsed an XML fragment using LINQ to XML and extracted the Child Element

  Values from the XML

Related Post

LINQ to XML Overview

LINQ to XML Classes Overview

XDocument Examples

XElement Example

XAttribute Example

LINQ to XML parse XML Elements

LINQ to XML parse Child Elements

LINQ to XML parse Attribute Values

LINQ to XML - Count Elements

LINQ to XML Filter on Element Values

LINQ to XML Filter on Attribute Values

LINQ to XML Add new Elements

LINQ to XML Update Element Values

LINQ to XML Update Attribute Values

LINQ to XML Delete Attributes

LINQ to XML Delete Elements

LINQ to XML Add Attributes

LINQ to XML parse XML Elements

In this post LINQ to XML parse XML Elements, we shall see how to parse a XML fragment and extract the Element values from the XML. In the post XElement Example, we have seen how to create XMLs using the XElement file, here we will see on how to parse the same XML  and extract the Element values.

Assume that we have the following XML fragment

   

  <Employees>

 <Employee>

<Name>

<FirstName>Henry</FirstName>

<LastName>Ford</LastName>

  </Name>

<Age>65</Age>

  </Employee>

  <Employee>

<Name>

<FirstName>Bill</FirstName>

<LastName>Gates</LastName>

</Name>

<Age>55</Age>

  </Employee>

  </Employees>

 Now we will parse the XML and get the list of Names from the XML, using the following code.

XElement xEmp = XElement.Load(@"D:\Employees.xml");

var empNames = from emps in xEmp.Elements("Employee")

               from name in emps.Elements("Name")

               select name;

foreach (XElement fName in empNames)

{

Response.Write(fName.Element("FirstName").Value + ", " +   fName.Element("LastName").Value + "</br>");

}

  When this code is executed, the following output will be Printed.    

Henry, Ford
Bill, Gates

  That’s it we have parsed an XML fragment using LINQ to XML and extracted the Element

  Values from the XML

Related Post

LINQ to XML Overview

LINQ to XML Classes Overview

XDocument Examples

XElement Example

XAttribute Example

LINQ to XML parse XML Elements

LINQ to XML parse Child Elements

LINQ to XML parse Attribute Values

LINQ to XML - Count Elements

LINQ to XML Filter on Element Values

LINQ to XML Filter on Attribute Values

LINQ to XML Add new Elements

LINQ to XML Update Element Values

LINQ to XML Update Attribute Values

LINQ to XML Delete Attributes

LINQ to XML Delete Elements

LINQ to XML Add Attributes