Link to home
Start Free TrialLog in
Avatar of raybetts
raybettsFlag for United Kingdom of Great Britain and Northern Ireland

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.
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of raybetts

ASKER

Anthony

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
Avatar of Jgould
Jgould

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
removed OT comments

JGould-EE Moderator