"helpful sql" <nospam@stopspam.com> wrote in message
news:%23H59V6VYFHA.2884@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.
>

"vMike" <Michael.George@spamnotgewarren.com.delete> wrote in message
news:Gt4le.8000$uR4.6337@newsread2.news.atl.earthlink.net...
>
> "helpful sql" <nospam@stopspam.com> wrote in message
> news:%23H59V6VYFHA.2884@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"))
>