PC Review


Reply
Thread Tools Rate Thread

Converting SQL Server data into XML for PPC

 
 
Raj
Guest
Posts: n/a
 
      24th Nov 2003
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
 
Reply With Quote
 
 
 
 
Alex Feinman [MVP]
Guest
Posts: n/a
 
      25th Nov 2003
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

"Raj" <(E-Mail Removed)> wrote in message
news:065101c3b2c6$b5813b40$(E-Mail Removed)...
> 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



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting daily data into weekly, monthly and yearly data CEGavinMcGrath Microsoft Excel Misc 3 1st Sep 2008 10:11 AM
Converting html data written as a Image (In Sql Server) back to html ? KK Microsoft C# .NET 1 22nd Feb 2005 05:05 PM
Converting an Oracle Data Reader into a SQL Server Data Reader Microsoft ADO .NET 3 20th Dec 2003 05:21 PM
Article: Converting SQL Server data to PDF format john farrow Microsoft C# .NET 0 23rd Oct 2003 04:17 AM
Converting XML data from SQL Server to Excel spreadsheets for reporting purposes John Rajendran Microsoft Excel Programming 0 16th Jul 2003 10:30 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:40 AM.