问题描述
任何人都可以帮忙吗?我需要将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.
推荐答案
这篇关于将XML发布到Web服务的逐步指南的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!