Displaying nested children elements in DataGridView

Hello,

Let say I have the following XML file :

<Patients>
<Patient>
<ID>100</ID>
<NAME>Sarah Readings</NAME>
<DESC>flu</DESC>
<FORMULA>
<PARAM>panadol</PARAM>
<PARAM>linsep</PARAM>
</FORMULA>
</Patient>
</Patients>

I would like to display this data in a DataGridView table. Normally I would load it to a DataSet and map it to a DataGridView. However, as the node <FORMULA> would have multiple children nodes <PARAM> this could not be done.

I imagine the output table would have two rows for this single record. With each row having the same identical <ID>, <NAME>,<DESC> value, but different <PARAM> value.

But I am not really sure. Could anyone suggest how to display this in correct way in DataGridView or any article sources that might help ( does this have anything to do with normalization)

Many thanks and regards,

Sharvie