Step by step guide to posting XML to a web service

Question

0.00/5 (No votes)

See more:

Can anyone help? I have a requirement to export some data from SQL server 2008 into XML format, then automatically save the results from my SQL query into as a .XML file, then convert this file using XSLT and lastly I need to post the converted file to a web service.

I have managed to retrieve the data into XML, save the results as a .XML file

I cannot figure out how to automatically send the data to a web service. I would love some code which states: If file exists then post.

I know the URL to send the .xml to and my file is in the correct format.

I imagine I would need to use some form of VB code, but I am a complete novice with VB. I have access to Visual Studio, but no real idea how to use it or how to deploy a project. If any one could offer up a solution I would be extremely grateful.

Posted 20-Aug-11 0:15am

Member 8175112

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ankur^\m/ · Answer 1 · 2011-08-20T00:29:00

When you are in doubt, remember that Google can definitely help you get started.
See these links:
XML Support in Microsoft SQL Server 2005[^]
Google search - sql to xml[^]
Google search - how to send data to a web service[^]

And yes, you can write code in any language to use a web service. It is language independent. Your data just needs to be serialised and follow the web service standards and formats.

Hope this gives you a start!