dataset to xml

[helpful sql]

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

Example:

<datasetname>
<tablename>
<column1name>va lue</column1name>
<column2name>va lue</column2name>
<column3name>va lue</column3name>
</tablename>
</databasename>

How can I do this?

Thanks.

[vMike]

Re: dataset to xml


"helpful sql" <nospam@stopspa m.com> wrote in message
news:%23H59V6VY FHA.2884@tk2msf tngp13.phx.gbl. ..[color=blue]
> Hi all,
> I have a DataSet with one table that has more than one row. I need to
> programmaticall y generate simple xml file from it. I need to include data
> from only one row.
>
> Example:
>
> <datasetname>
> <tablename>
> <column1name>va lue</column1name>
> <column2name>va lue</column2name>
> <column3name>va lue</column3name>
> </tablename>
> </databasename>
>
> How can I do this?
>
> Thanks.
>[/color]
dim ds as dataset = yourdataset
ds.writexml("st rpathandfilenam e"))

[vMike]

Re: dataset to xml


"vMike" <Michael.George @spamnotgewarre n.com.delete> wrote in message
news:Gt4le.8000 $uR4.6337@newsr ead2.news.atl.e arthlink.net...[color=blue]
>
> "helpful sql" <nospam@stopspa m.com> wrote in message
> news:%23H59V6VY FHA.2884@tk2msf tngp13.phx.gbl. ..[color=green]
> > Hi all,
> > I have a DataSet with one table that has more than one row. I need to
> > programmaticall y generate simple xml file from it. I need to include[/color][/color]
data[color=blue][color=green]
> > from only one row.
> >
> > Example:
> >
> > <datasetname>
> > <tablename>
> > <column1name>va lue</column1name>
> > <column2name>va lue</column2name>
> > <column3name>va lue</column3name>
> > </tablename>
> > </databasename>
> >
> > How can I do this?
> >
> > Thanks.
> >[/color]
> dim ds as dataset = yourdataset
> ds.writexml("st rpathandfilenam e"))
>[/color]
for one row you would need to get table(0) of the dataset and do a select
first.