prasadmokashi
Programmer
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
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