Building a datagrid table

[billrogers]

If I have xml that looks like this:

<map name="Louisville">
<street name="Libby Lane">
<house id="100" name="Jones" />
<house id="101" name="Wilbur" />
</street>
<street name="Belland Ave">
<house id="100" name="Johnson" />
<house id="101" name="Smith" />
</street>
</map>


Is it possible to have that displayed in a datagrid like


Louisville
Libby Lane
100 Jones
101 Wilbur
Belland Ave
100 Johnson
101 Smith


It seems like with the way the xml is the datagrid views each thing as a table so it has a map table then a city table and then a street table.