how to create a master detail display on the datagrid

[Cecille Regidor]

When I read an xml file, the read data will be converted into different
tables with the relationship. But how can I display the data into a
relational table like the data grid?

 

[W.G. Ryan eMVP]

If the tables have a relationship (datarelation) set up between them, then
just set the Datasource of the grid to the dataset.

 

[Cecille Regidor]

thanks... but this is what I have, i have an xml with the following format.

Root ClientKey="0">
<Areas>
<Area ClientKey="1" name="AREA_A" index="0">
<Modules>
<Module ClientKey="2" name="LIC-549" description="Can I make more
than" />
<Module ClientKey="3" name="LOOP" description="Control Module" />
<Module ClientKey="4" name="TIC-205" description="One change"/>
</Modules>
</Area>
</Areas>
</Root>


then I want my data to look like this

Area_Name Area_Index Module_ClientKey Module_Name Module_Description
AREA_A 0 2 LIC-549 Can I make more than
AREA_A 0 3 LOOP Control Module
AREA_A 0 4 TIC-205 One change



I was able to combine all the rows of the table into a one datatable my
problem is how to filter them to look like the above table.


thanks...