IS There A Way TO Download Data F Sql To Xml File

alyeng2000 · March 16th, 2005, 05:27 PM

Hi all,

Can Any Help To Show Me A way To Download Data From Sql Server To Xml File To The Client Side To Deal With It Using Microsoft Xml ActiveX Object.

Ahmed Ali
Software Developer

jbenson001 · March 19th, 2005, 01:36 AM

You can use the dataset WriteXML method to generate an XML file, then use that with your ActiveX object.

alyeng2000 · March 21st, 2005, 02:11 AM

i searched and i found that i have to use webservice to do functions over the xml file from client side . but how???

Ahmed Ali
Software Developer

mehdi62b · March 22nd, 2005, 10:11 AM

I once made a class for my table in sqlserver this class had some public

properties and then in webservice I populated it from my datasource(ADO.NET)

and returned it,then webservice serialized and displayed my object in XMl

format,I think you can return a dataset as well.

(U know there is no file to be saved on the client just to be displayed on the explorer!)

_____________
Mehdi.
software student.

shenku · April 28th, 2005, 09:22 AM

select * from categories for xml auto, elements

This will return an xml string. Then you can do whatever you like with it stick it in an XMl Object and fly it to the moon if you like. Though probably you wont be able to save it to the clients machine. Unless maybe in a cookie or session that this "ActiveX" object can pick up?