show the nested table as a column and bind it to data grid

H

Hari

Hi
I am using the XML that is hierarchial and when I load the XML into dataset and bind the dataset to datagrid, I was not able to see the low level data. for example my xml looks like as follows
==========
<GetMyTimesheet><Assignments><Assignment><WUID>150</WUID><Work>4800000</Work><TaskName>2 Task d</TaskName><TimephasedDataSegments><TimephasedData><WUID>150</WUID><Day>20040405000000</Day></TimephasedData></TimephasedDataSegments></Assignment><Assignment><WUID>154</WUID><Work>4800000</Work><TaskName>2 Task e</TaskName><TimephasedDataSegments><TimephasedData><WUID>154</WUID><Day>20040405000000</Day></TimephasedData><TimephasedData><WUID>154</WUID><Day>20040415000000</Day></TimephasedData></TimephasedDataSegments></Assignment></Assignments><MyData><TimePhasedData><WASSN_ID>150</WASSN_ID><WWORK_E_VALUE>0</WWORK_E_VALUE></TimePhasedData><TimePhasedData><WASSN_ID>154</WASSN_ID><WWORK_E_VALUE>20000</WWORK_E_VALUE></TimePhasedData></MyData></GetMyTimesheet
=========
I was able to see only these two columns when I databound with the datagrid.
<WUID>154</WUID><Work>4800000</Work><TaskName>2 Task e</TaskName>

Actually I wanted to see
<WUID>154</WUID><Work>4800000</Work><TaskName>2 Task e</TaskName>
and
<WASSN_ID>154</WASSN_ID><WWORK_E_VALUE>20000</WWORK_E_VALUE>

this XML is not at the same level but WUID and WASSN_ID is same. So I want to show WWORK_E_VALUE as an extra column in data grid.

what is the best method for this

Thank
--krishna
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
474,266
Messages
2,571,085
Members
48,773
Latest member
Kaybee

Latest Threads

Top