Sample File:
<EMPLOYEES>
<EMPLOYEE>
<EMPID>110404</EMPID>
<FIRST_NAME>JOHN</FIRST_NAME>
<LAST_NAME>QARTAR</LAST_NAME>
<JOIN_DATE>2014-12-17</JOIN_DATE>
<DESIGNATION>
<VALUE>OFFICER</VALUE>
<VALUE>SENIOR OFFICER</VALUE>
</DESIGNATION>
<LAST_PROMOTION>
<VALUE>2014-12-17</VALUE>
</LAST_PROMOTION>
</EMPLOYEE>
</EMPLOYEES>
My Code:
var individuals =
from Linq_tab in xmlDoc.Descendants("EMPLOYEE")
select new objEMPLOYEE
{
EMPID = (string)Linq_tab.Element("EMPID"),
FIRST_NAME = (string)Linq_tab.Element("FIRST_NAME"),
LAST_NAME = (string)Linq_tab.Element("LAST_NAME"),
JOIN_DATE = (string)Linq_tab.Element("JOIN_DATE"),
DESIGNATION = new DESIGNATION_LIST()
{
VALUES_DESIGNATIONS = new List<DESIG>(from val in Linq_tab.Descendants("DESIGNATION")
select new DESIG
{
VALUE = (string)val.Element("VALUE"),
})
},
LAST_PROMOTION = new LAST_PROMOTION_LIST()
{
VALUES_LAST_PROMOTION = new List<LAST_PROMOTION>(from val in Linq_tab.Descendants("LAST_PROMOTION")
select new LAST_PROMOTION
{
VALUE = (string)val.Element("VALUE"),
})
}
};
Everything is working good but DESIGNATION. only first row is returned. How can I read both row of designation with same tag name "VALUE"?
Thanks in advance.
No comments:
Post a Comment