Save SQL data in xml and retrieve back

[ADH]

What is the eayest and shortest way to save an SQL SELECT output in to a local XML file and retrieve it back as table rows by another program ?
Thanks, adh

 

[mH_p0rtal]

dim m as new dataset
m.readxml(server.mappath("mh.xml"))
datagrid.datasource = m
datagrid.databind

write to xml from sql connection

dim da as new sqldataadapter
dim mm as new dataset
da.fill(mm);
da.writexml(server.mappath("ohyea.xml"))

as easy as piece of cake

 

[ADH]

Oh yeah ...................

Thanks (I had the feeling I was at the wrong direction......)
adh