How to retreive as one Table

[skid_myanmar]

Hi...i would like to know how to retreive all these xml data as one record in table by DataSet or XmlDataDocument...and i would like to know that I can retreive or not... only required column from XML by using XSL or XSD....i wanna omit some Columns


<?xml version="1.0" encoding="UTF-8" ?>
<ROW>
<COL>
<DATA>a</DATA>
</COL>
<COL>
<DATA>b</DATA>
</COL>
<COL>
<DATA>c</DATA>
</COL>
<COL>
<DATA>d</DATA>
</COL>



Thanks

[skid_myanmar]

Hi all,
For example, I hav this xml

<?xml ...?>
<tablename>abc</tablename>
<version>1</version>
<resultset>
<row>
<col>abc</col>
<col>def</col>
</row>
</resultset>

And I only want to filter not to include <tablename> and <version> in coresponding object. eg. DataSet or XmlDataDocument...by using XSL or XSD...how can i acheive it


Thanks

Skid