I have 2 XML files as follows -
one.xml
=======
<?xml version="1.0" standalone="yes"?>
<CMS>
<Episode>
<name>Mentor: Communicating Effectively</name>
</Episode>
<Episode>
<name>Facilitator: Managing Conflict</name>
</Episode>
<Episode>
<name>Monitor: Measuring Performance</name>
</Episode>
</CMS>
two.xml
=======
<CMS>
<Episode>
<eNumber>1</eNumber>
<partOne>0</partOne>
<partTwo>1</partTwo>
</Episode>
<Episode>
<eNumber>2</eNumber>
<partOne>1</partOne>
<partTwo>0</partTwo>
</Episode>
<Episode>
<eNumber>3</eNumber>
<partOne>0</partOne>
<partTwo>1</partTwo>
</Episode>
</CMS>
Now, I want to merge these two XML documents and display them on the datagrid in the following format -
Episode Name , Part A , Part B
======================
Mentor: Communicating Effectively, Checkbox , Checkbox
Facilitator: Managing Conflict, Checkbox , Checkbox
Monitor: Measuring Performance, Checkbox, Checkbox
I tried using two datasets and merge them, but it returns all the rows. I also tried using two datatables, but no luck yet!
Help is urgent!
Thanks in advance,
Aditi