hello daniweb please I woiuld like help on how to convert rss feeds to datagrid in this fomat
<Row>
<Cell><Data ss:Type="String">Symbol</Data></Cell>
<Cell><Data ss:Type="String">Close</Data></Cell>
<Cell><Data ss:Type="String">Prev</Data></Cell>
<Cell><Data ss:Type="String">Chg</Data></Cell>
<Cell><Data ss:Type="String">% Chg</Data></Cell>
<Cell><Data ss:Type="String">Open</Data></Cell>
<Cell><Data ss:Type="String">High</Data></Cell>
<Cell><Data ss:Type="String">Low</Data></Cell>
<Cell><Data ss:Type="String">Avg</Data></Cell>
<Cell><Data ss:Type="String">Deals</Data></Cell>
<Cell><Data ss:Type="String">Vol</Data></Cell>
<Cell><Data ss:Type="String">Value</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">7UP</Data></Cell>
<Cell><Data ss:Type="Number">41.75</Data></Cell>
<Cell><Data ss:Type="Number">41.75</Data></Cell>
<Cell><Data ss:Type="Number">0</Data></Cell>
<Cell><Data ss:Type="Number">0</Data></Cell>
<Cell><Data ss:Type="Number">41.75</Data></Cell>
<Cell><Data ss:Type="Number">41.75</Data></Cell>
<Cell><Data ss:Type="Number">41.75</Data></Cell>
<Cell><Data ss:Type="Number">39.67</Data></Cell>
<Cell><Data ss:Type="Number">11</Data></Cell>
<Cell ss:StyleID="s16"><Data ss:Type="Number">25188</Data></Cell>
<Cell ss:StyleID="s16"><Data ss:Type="Number">999222.96</Data></Cell>
</Row>
the values in the first <row> </row> of data are the column headings for the corresponding cells in the other <row> </row>
considering that I can work with xml in the other format this is quite strange so any help will be needed. Thanks