raybetts
asked on
SQL Server 2000 and XML
Hi
As you all know, SQL 200 gives us the ability to show are SQL results in XML!
Normally in the past before the feature was available I would take my ADO disconnected RS and place it in an array or into XML and ship it off to the client.
My questions is........
Given that the SQL is being returned in an XML format, do I still use ADO or do I use something else. Any brief code showing how I do this would be helpful.
Thanks
Ray.
As you all know, SQL 200 gives us the ability to show are SQL results in XML!
Normally in the past before the feature was available I would take my ADO disconnected RS and place it in an array or into XML and ship it off to the client.
My questions is........
Given that the SQL is being returned in an XML format, do I still use ADO or do I use something else. Any brief code showing how I do this would be helpful.
Thanks
Ray.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Gentlemen guess this is settled then, since this was a *half answered question* i just split the points in half and move the question to PAQ accepting the comment from Anthony
JGould-EE Moderator
JGould-EE Moderator
removed OT comments
JGould-EE Moderator
JGould-EE Moderator
ASKER
Thanks, it makes things a bit clearer now. Could you either post some code showing how the stream is used?
Im lazy and its Friday! I did what you asked of me (closing open questions) - I would delete if they hadn't taken the option away from me!
Thanks,
Ray