How to get child attribute value from XML file using c#

Question

I am having xml file with name as employeesInfo and in that the data is like

<?xml version="1.0" encoding="utf-8"?>
<EmployeeDetails>
  <data>
    <empCode>DIT-GINT-0001</empCode>
    <FirstName>Dinesh</FirstName>
    <LastName>Alla</LastName>
    <Address>Guntur</Address>
  </data>
  <EmployeeDetails>
    <empCode>DIT-GINT-0002</empCode>
    <FirstName>Upendra</FirstName>
    <LastName>Maddi</LastName>
    <Address>guntur</Address>       
  </EmployeeDetails>
  <EmployeeDetails>
    <empCode>DIT-GINT-0003</empCode>
    <FirstName>Chandrkanth</FirstName>
    <LastName>Beth</LastName>
    <Address>guntur</Address>       
  </EmployeeDetails>
</EmployeeDetails>

And My code to get attribute{"empCode"} value is

XDocument doc = XDocument.Load(System.Web.HttpContext.Current.Server.MapPath("~/employeesInfo.xml"));
XElement root = doc.Root;
string s = root.Elements("empCode").Last().ToString();

Requirement: I want to get empcode value of last parent element.

Example output of the above file: DIT-GINT-0003

BISOFT Dev. · Accepted Answer · 2017-08-02 10:39:53Z

2

In your code sample root is <EmployeeDetails>. Get its childnodes and select the last one, then get the <empCode> of this node. I am sorry that I am writing this as an answer, I don't have enough reputation.

XElement lastEmployeeDetails = root.LastNode;

answered Aug 2, 2017 at 10:39

BISOFT Dev.

363 bronze badges

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

Comments

zx485 · Accepted Answer · 2017-08-02 10:52:10Z

2

To get the last element and specific value in your case

XDocument doc = XDocument.Load(System.Web.HttpContext.Current.Server.MapPath("~/employeesInfo.xml"));
XElement root = doc.Root;
string s = root.Element("EmployeeDetails").Element("empCode").LastNode.ToString();

edited Aug 2, 2017 at 10:52

zx485

29.1k28 gold badges55 silver badges65 bronze badges

answered Aug 2, 2017 at 10:46

raichiks

2864 silver badges16 bronze badges

Comments

Abdul Ahad · Accepted Answer · 2017-08-02 11:30:57Z

1

This can do the work -

XDocument doc = XDocument.Load(@"D:\Temp\asd.xml");
var s = doc.Descendants("empCode").Last().Value;

To check whether the node exists or not -

XDocument doc = XDocument.Load(@"D:\Temp\asd.xml");
var empCodes = doc.Descendants("empCode");
string result = string.Empty;

if(empCodes.Count() > 0)
{
     result = empCodes.Last().Value;
}

edited Aug 2, 2017 at 11:30

answered Aug 2, 2017 at 10:48

Abdul Ahad

2,2314 gold badges25 silver badges39 bronze badges

1 Comment

Dinesh Reddy Alla Over a year ago

It works fine, I am having small doubt if suppose i am running the application for the first time then in the XML file i will not have "empcode" attribute, at that time how should i check.

Collectives™ on Stack Overflow

How to get child attribute value from XML file using c#

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related