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

Discussion in 'ASP .Net Datagrid Control' started by Hari, Apr 13, 2004.

  1. Hari

    Hari Guest

    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
     
    Hari, Apr 13, 2004
    #1
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. AD
    Replies:
    1
    Views:
    1,062
    Francis Shanahan
    Aug 23, 2003
  2. Random
    Replies:
    1
    Views:
    4,702
    Random
    Nov 19, 2004
  3. mr2_93
    Replies:
    1
    Views:
    3,648
    mr2_93
    Oct 2, 2005
  4. savvy
    Replies:
    1
    Views:
    492
    savvy
    Jan 18, 2006
  5. Neil Chambers
    Replies:
    0
    Views:
    407
    Neil Chambers
    Sep 4, 2008
Loading...

Share This Page