luckyads 0 Light Poster

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.