将XML发布到Web服务的逐步指南 [英] Step by step guide to posting XML to a web service

问题描述

任何人都可以帮忙吗?我需要将SQL Server 2008中的某些数据导出为XML格式，然后将来自SQL查询的结果自动保存为.XML文件，然后使用XSLT转换此文件，最后我需要将转换后的文件发布到Web上服务.

我设法将数据检索为XML，并将结果另存为.XML文件

我无法弄清楚如何自动将数据发送到Web服务.我喜欢一些说明以下内容的代码:如果文件存在，则发布.

我知道将.xml发送到的URL，并且我的文件格式正确.

我想我需要使用某种形式的VB代码，但是我是VB的一个新手.我可以使用Visual Studio，但没有真正的主意如何使用它或如何部署项目.如果有人可以提出解决方案，我将万分感谢.

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.

推荐答案

如果您有疑问，请记住Google绝对可以帮助您入门. > 请参阅以下链接:
Microsoft SQL Server 2005中的XML支持 [ ^ ]
Google搜索-如何将数据发送到网络服务 [

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!

这篇关于将XML发布到Web服务的逐步指南的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！