[RESOLVED] Dataset readxml - read only certain elements(columns)

[akhileshbc]

Hi guys

Dataset's ReadXML() method would read an XML document. But how would we skip certain columns ?

For example:

<product>
  <book>
    <id>1</id>
    <name>abc1</name>
    <price>Rs. 100</price>
  </book>
  <book>
    <id>2</id>
    <name>abc2</name>
    <price>Rs. 250</price>
  </book>
  <book>
    <id>3</id>
    <name>aaasd</name>
    <price>Rs. 12345</price>
  </book>
</product>

So, if I use ReadXML(), it would read the whole document and the dataTable would have "id" column, "name" column and "price" column.

But I want to have only "id" and "name" column. How can I skip certain columns from reading it ?

Thanks