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]

"helpful sql" <no****@stopspam.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

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]

"vMike" <Mi************@spamnotgewarren.com.delete> wrote in message
news:Gt*****************@newsread2.news.atl.earthl ink.net...

"helpful sql" <no****@stopspam.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

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"))

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