Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

One Datatable out of two

Status
Not open for further replies.

prasadmokashi

Programmer
Oct 31, 2003
41
US
Hello,

I have a data in following xml format

<GraphData>
<days>10</days>
<yield stream="mystream">100</yield>
<yield stream="yourstream">200</yield>
</GraphData>
<GraphData>
<days>20</days>
<yield stream="mystream">250</yield>
<yield stream="yourstream">300</yield>
</GraphData>

When I create a dataset out of this xml, it creates two dataTables one "GraphData" and other is "yield"

For the purpose of creating chart I would prefer to have data in the following format.

days mystream yourstream
10 100 200
20 250 300

Is there any way of converting the two datatables into the one like above ?

Thanks,
Prasad
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top