Converting SQL Server data into XML for PPC

[Raj]

Hi!
I managed to implement webservices on a PPC in an
application that uses data in an XML file. But I had
created the file manually. Now I have created some stored
procedures in SQL Server 2000 with queries that use 'FOR
XML AUTO' to put the data in an XML format. Now how do I
access this data from the PPC application?Where do I
store the data on the device? Is there any sequence of
steps that needs to be followed?
I am using C# and I do not want to use SQL Server CE for
data access. Does anyone have some advice/suggestions
about this?
Thanks and regards,
Raj

 

[Alex Feinman [MVP]]

You can use Managed SQLXML provider in your web service. This will allow
youto obtain XmlDocument as a query result. XmlDocument used as a Web
Service return value actually becomes the SOAP response - there is nothing
added to it at all.
This way on the PPC side you will also receive a pure data XML, which you
are free to deal with as you wish