C# Guide - C#, Asp.Net, MVC, LINQ, jQuery and SharePoint Resources

LINQ to XML Update Element Values

In this post LINQ to XML Update Element Values, we shall see how to update the values of elements in an existing XML structure. We will load an XML file from the disk, update the values of the elements and save the updated XML to the disk.

Assume that we have the following XML fragment

<Name>

<FirstName>Henry</FirstName>

</Name>

</Employee>

<Name>

<LastName>Gates</LastName>

</Name>

</Employee>

<Name>

<FirstName>Steve</FirstName>

</Name>

</Employee>

</Employees>

Now we will update the value of the Age Element, for the Employee Henry Ford.

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

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

where emps.Element("Name").Element("FirstName").Value.Equals("Henry")

select emps;

empDetails.First().Element("Age").Value = "60";

xEmp.Save(@"D:\Employees.xml");

When this code is executed, the Employees.xml file will contain the following tags.

<Name>

<FirstName>Henry</FirstName>

</Name>

</Employee>

<Name>

<LastName>Gates</LastName>

</Name>

</Employee>

<Name>

<FirstName>Steve</FirstName>

</Name>

</Employee>

</Employees>

That’s it we have updated the value of the Age element in the XML saved the changes to the Disk.

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 Add new Elements

In this post LINQ to XML Add new Elements, we shall see how to add new elements to an existing XML structure. We will load an XML file from the disk, add a new element to the existing collection and save the updated XML to the disk.

Assume that we have the following XML fragment

<Name>

<FirstName>Henry</FirstName>

</Name>

</Employee>

<Name>

<LastName>Gates</LastName>

</Name>

</Employee>

</Employees>

Now we will add a new Employee tag to the XML file and save the changes.

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

xEmp.Add(

new XElement("Employee",

new XElement("Name",

new XElement("FirstName", "Steve"),

new XElement("LastName", "Jobs")

new XElement("Age", "75"),

new XElement("Department", new XAttribute("Name","Mobile"))

)

);

xEmp.Save(@"D:\Employees.xml");

When this code is executed, the Employees.xml file will contain the following tags.

<Name>

<FirstName>Henry</FirstName>

</Name>

</Employee>

<Name>

<LastName>Gates</LastName>

</Name>

</Employee>

<Name>

<FirstName>Steve</FirstName>

</Name>

</Employee>

</Employees>

That’s it we have added a new Element to an XML file and saved the changes to the Disk.

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 Filter on Element Values

In this post LINQ to XML Filter on Element Values, we shall see how to filter the XML tags based on a specific element value. In the post LINQ to XML parse XML Elements, we saw how to extract values from all elements, here we shall see on how get the values of elements after applying a filter.

Assume that we have the following XML fragment

<Name>

<FirstName>Henry</FirstName>

</Name>

</Employee>

<Name>

<LastName>Gates</LastName>

</Name>

</Employee>

</Employees>

Now we will parse the XML and get the details of Employees whose age is 55.

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

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

where emps.Element("Age").Value.Equals("55")

select emps;

Response.Write("Employee Count: " + empNames.Count() + " "");

foreach (XElement empDetails in empNames)

{

Response.Write("Name: " + empDetails.Element("Name").Element("FirstName").Value + "");

Response.Write("Age: " + empDetails.Element("Age").Value + ");

Response.Write("Department: " + empDetails.Element("Department").Attribute("Name").Value + ");

}

When this code is executed, the output will be

Employee Count: 1

Name: Bill
Age: 55
Department: Software

Notice that though we had the details of 2 employees in the XML only the details of the Employee with an Age of 55 is displayed in the Output, the LINQ query has applied a filter on the XML and displays only the filtered results.

That’s it we have filtered an XML fragment using LINQ Query and displayed the filtered results.