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