dataset to xml

[helpful sql]

Hi all,
I have a DataSet with one table that has more than one row. I need to
programmatically generate simple xml file from it. I need to include data
from only one row.

Example:

<datasetname>
<tablename>
<column1name>value</column1name>
<column2name>value</column2name>
<column3name>value</column3name>
</tablename>
</databasename>

How can I do this?

Thanks.

 

[vMike]

Hi all,
I have a DataSet with one table that has more than one row. I need to
programmatically generate simple xml file from it. I need to include data
from only one row.

Example:

<datasetname>
<tablename>
<column1name>value</column1name>
<column2name>value</column2name>
<column3name>value</column3name>
</tablename>
</databasename>

How can I do this?

Thanks.

dim ds as dataset = yourdataset
ds.writexml("strpathandfilename"))

 

[vMike]

dim ds as dataset = yourdataset
ds.writexml("strpathandfilename"))

for one row you would need to get table(0) of the dataset and do a select
first.