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

Recommended Answers

All 3 Replies

I would imagine if you affix XML headers to those Nodes, you could parse them with the XML parser or Linq to XML.

pls could you explain further

Sure. Take a look at this thread
Your data is a lot like that except is has a "header" that states it is XML.
If your RSS had the same "header" -- making it then XML, you could use the XML parser like my example shows in that thread.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.