经典ASP到.NET WebService接口（数据集到RecordSet） [英] Classic ASP to .NET WebService interfacing (Dataset to RecordSet)
问题描述
我正在尝试编写一个将.NET服务器连接到
经典ASP服务器的例程。
我知道以下代码没有'干嘛！数据作为
数据集返回，但ASP无法识别数据集并需要记录集。
数据类型是否可以转换？在Classic ASP端还是.NET端？可以用
SOAP工具包提供转换，任何工具包都可以提供转换吗？
================ ================================== ================ ================
网络服务代码：
---------- -----------
dim strSelect as string
dim srcData as ODBCconnection
dim fltData as ODBCdataAdapter
将myPath作为字符串调整
myPath = me.Context.Request.ServerVariables（" APPL_PHYSICAL_ PATH"）
dim rtnData as DataSet
strSelect =" SELECT * FROM myDataSource"
''srcData = new ODBCConnection（" PROVIDER = Microsoft.Jet .OLEDB.4.0;数据
SOURCE ="& myPath&" .. \\\ data \ myDataSource.mdb"）
srcData = new ODBCConnection（" DSN = MyDataSource; uid =; pwd ="）
fltData = new ODBCdataAdapter（strSelect，srcData）
rtnData = n新数据集
fltData.fill（rtnData）
返回rtnData
==== ============================================== ==== ============================
ASP Web服务器代码：
-------------------------
SET objSoapClient = Server.CreateObject（" MSSOAP .SoapClient"）
''需要使用您的Web服务WSDL的URL进行更新，并且
''后跟Web服务名称
objSoapClient.ClientProperty（" ServerHTTPRequest"）= True
致电
objSoapClient.mssoapinit（" http：// system。 evolucion.co.uk/evolucion-services.asmx?WSDL"）
set RecordSet = Server.CreateObject（" ADODB.Recordset"）
''使用SOAP对象调用所需的Web方法
RecordSet = objSoapClient.getEvolucionVersionList（）
strOutput = strOutput& < P>在线结果： &安培; RecordSet.RecordCount
=================================== =============== ================================
I am trying to write a routine that will connect a .NET server with a
classic ASP server.
I know the following code doesn''t work! The data is being returned as a
dataset, however ASP does not recognise datasets and requires a recordset.
Can the datatypes be converted? At the Classic ASP end or .NET end? Can
SOAP toolkit provide the conversion, can any toolkit provide a conversion?
================================================== ================================
Web Service Code :
---------------------
dim strSelect as string
dim srcData as ODBCconnection
dim fltData as ODBCdataAdapter
dim myPath as String
myPath = me.Context.Request.ServerVariables("APPL_PHYSICAL_ PATH")
dim rtnData as DataSet
strSelect = "SELECT * FROM myDataSource"
'' srcData = new ODBCConnection( "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA
SOURCE=" & myPath & "..\data\myDataSource.mdb" )
srcData = new ODBCConnection( "DSN=MyDataSource;uid=;pwd=" )
fltData = new ODBCdataAdapter( strSelect, srcData )
rtnData = new dataset
fltData.fill( rtnData )
return rtnData
================================================== ================================
ASP Web Server Code:
-------------------------
SET objSoapClient = Server.CreateObject("MSSOAP.SoapClient")
'' needs to be updated with the url of your Web Service WSDL and is
'' followed by the Web Service name
objSoapClient.ClientProperty("ServerHTTPRequest") = True
Call
objSoapClient.mssoapinit("http://system.evolucion.co.uk/evolucion-services.asmx?WSDL")
set RecordSet = Server.CreateObject("ADODB.Recordset")
'' use the SOAP object to call the Web Method Required
RecordSet = objSoapClient.getEvolucionVersionList()
strOutput = strOutput & "<P>On-Line Result : " & RecordSet.RecordCount
================================================== ================================
推荐答案
尝试将它作为可以使用的东西传递，XML也许？
-
Curt Christianson
网站&脚本： http://www.Darkfalz.com
博客： http://blog.Darkfalz.com
" Adam Short <广告** @ phuture-uk.net>在消息中写道
news：Ob ************** @ TK2MSFTNGP14.phx.gbl ...
try passing it as something both can work with, XML perhaps?
--
Curt Christianson
Site & Scripts: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Adam Short" <ad**@phuture-uk.net> wrote in message
news:Ob**************@TK2MSFTNGP14.phx.gbl...
我正在写将.NET服务器与经典ASP服务器连接起来的例程。
我知道以下代码不起作用！数据作为
数据集返回，但ASP无法识别数据集并需要记录集。
数据类型是否可以转换？在Classic ASP端还是.NET端？可以为SOAP工具包提供转换，可以为任何工具包提供转换吗？
======================== ========================== ======================== ========
网络服务代码：
---------------------
dim strSelect as string
dim srcData as ODBCconnection
dim fltData as ODBCdataAdapter
dim myPath as String
myPath = me.Context.Request.ServerVariables（" ; APPL_PHYSICAL_ PATH"）
dim rtnData as DataSet
strSelect =" SELECT * FROM myDataSource"
'srcData = new ODBCConnection（" ; PROVIDER = Microsoft.Jet.OLEDB.4.0; DATA
SOURCE ="& myPath&" .. \ data \ myDataSource.mdb"）
srcData = new ODBCConnection（" DSN = MyDataSource; uid =; pwd ="）
fltData = new ODBCdataAdapter（strSelect，srcData）
rtnData = new dataset
< brt> fltData.fill（rtnData）
返回rtnDa ta
========================================= ========= ================================
ASP Web服务器代码：
-------------------------
SET objSoapClient = Server.CreateObject（" MSSOAP.SoapClient"）
''需要使用Web服务WSDL的url进行更新，然后是
''后跟Web服务名称
objSoapClient .ClientProperty（" ServerHTTPRequest"）= True
调用
objSoapClient.mssoapinit（" http：//system.evolucion.co.uk/evolucion-services.asmx？WSDL"）
设置RecordSet = Server.CreateObject（" ADODB.Recordset"）
''使用SOAP对象调用所需的Web方法
RecordSet = objSoapClient。 getEvolucionVersionList（）
strOutput = strOutput& < P>在线结果： &安培; RecordSet.RecordCount
======================================= =========== ================================
I am trying to write a routine that will connect a .NET server with a
classic ASP server.
I know the following code doesn''t work! The data is being returned as a
dataset, however ASP does not recognise datasets and requires a recordset.
Can the datatypes be converted? At the Classic ASP end or .NET end? Can
SOAP toolkit provide the conversion, can any toolkit provide a conversion?
================================================== ================================
Web Service Code :
---------------------
dim strSelect as string
dim srcData as ODBCconnection
dim fltData as ODBCdataAdapter
dim myPath as String
myPath = me.Context.Request.ServerVariables("APPL_PHYSICAL_ PATH")
dim rtnData as DataSet
strSelect = "SELECT * FROM myDataSource"
'' srcData = new ODBCConnection( "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA
SOURCE=" & myPath & "..\data\myDataSource.mdb" )
srcData = new ODBCConnection( "DSN=MyDataSource;uid=;pwd=" )
fltData = new ODBCdataAdapter( strSelect, srcData )
rtnData = new dataset
fltData.fill( rtnData )
return rtnData
================================================== ================================
ASP Web Server Code:
-------------------------
SET objSoapClient = Server.CreateObject("MSSOAP.SoapClient")
'' needs to be updated with the url of your Web Service WSDL and is
'' followed by the Web Service name
objSoapClient.ClientProperty("ServerHTTPRequest") = True
Call
objSoapClient.mssoapinit("http://system.evolucion.co.uk/evolucion-services.asmx?WSDL")
set RecordSet = Server.CreateObject("ADODB.Recordset")
'' use the SOAP object to call the Web Method Required
RecordSet = objSoapClient.getEvolucionVersionList()
strOutput = strOutput & "<P>On-Line Result : " & RecordSet.RecordCount
================================================== ================================
DataSet和RecordSet对象不兼容 - 数据集代表一个
整个数据库（包括表，关系等），而记录集
表示数据的二维视图（表，视图，存储结果
在我看来，你需要更好地构建您的解决方案。您可以从Web服务返回
a记录集对象，或者二维数组。
-
Manohar Kamath
编辑，.netWire
www.dotnetwire.com
" Adam Short" <广告** @ phuture-uk.net>在消息中写道
news：Ob ************** @ TK2MSFTNGP14.phx.gbl ...
The DataSet and RecordSet objects are not compatible -- Dataset represents a
whole database (including tables, relations, etc.), while the recordset
represents two-dimensional view of data (Table, view, result from stored
proc, etc)
In my opinion, you need to architect your solution better. You could return
a recordset object from the webservice, or a two-dimensional array.
--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com
"Adam Short" <ad**@phuture-uk.net> wrote in message
news:Ob**************@TK2MSFTNGP14.phx.gbl...
我正在写将.NET服务器与经典ASP服务器连接起来的例程。
我知道以下代码不起作用！数据作为
数据集返回，但ASP无法识别数据集并需要记录集。
数据类型是否可以转换？在Classic ASP端还是.NET端？可以为SOAP工具包提供转换，任何工具包都可以提供转换吗？
==================== ============================== ==================== ======
======
网络服务代码：
------------------ ---
dim strSelect as string
dim srcData as ODBCconnection
dim fltData as ODBCdataAdapter
dim myPath as String
myPath = me .Context.Request.ServerVariables（" APPL_PHYSICAL_ PATH"）
dim rtnData as DataSet
strSelect =" SELECT * FROM myDataSource"
''srcData = new ODBCConnection（" PROVIDER = Microsoft.Jet.OLEDB.4.0; DATA
SOURCE ="& myPath&" .. \ dataata \ myDataSource.mdb"）
srcData = new ODBCConnection（" DSN = MyDataSource; uid =; pwd ="）
fltData = new ODBCdataAdapter（strSelect，srcData）
rtnData =新数据集
fltData.fill（rtnData）
返回rtnData
============================== ==================== ==========================
======
ASP Web服务器代码：
-------------------------
SET objSoapClient = Server.CreateObject（" MSSOAP.SoapClient"）
''需要使用Web服务WSDL的url进行更新，并且是
''其次是Web服务名称
objSoapClient.ClientProperty（" ServerHTTPRequest"）= True
调用
objSoapClient.mssoapinit（" http： //system.evolucion.co.uk/evolucion-services.a
smx？WSDL"）
设置RecordSet = Server.CreateObject（" ADODB.Recordset"）
''使用SOAP对象调用所需的Web方法
RecordSet = objSoapClient.getEvolucionVersionList（）
strOutput = strOutput& < P>在线结果： &安培; RecordSet.RecordCount
=================================== =============== ==========================
= =====
I am trying to write a routine that will connect a .NET server with a
classic ASP server.
I know the following code doesn''t work! The data is being returned as a
dataset, however ASP does not recognise datasets and requires a recordset.
Can the datatypes be converted? At the Classic ASP end or .NET end? Can
SOAP toolkit provide the conversion, can any toolkit provide a conversion?
================================================== ==========================
======
Web Service Code :
---------------------
dim strSelect as string
dim srcData as ODBCconnection
dim fltData as ODBCdataAdapter
dim myPath as String
myPath = me.Context.Request.ServerVariables("APPL_PHYSICAL_ PATH")
dim rtnData as DataSet
strSelect = "SELECT * FROM myDataSource"
'' srcData = new ODBCConnection( "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA
SOURCE=" & myPath & "..\data\myDataSource.mdb" )
srcData = new ODBCConnection( "DSN=MyDataSource;uid=;pwd=" )
fltData = new ODBCdataAdapter( strSelect, srcData )
rtnData = new dataset
fltData.fill( rtnData )
return rtnData
================================================== ==========================
======
ASP Web Server Code:
-------------------------
SET objSoapClient = Server.CreateObject("MSSOAP.SoapClient")
'' needs to be updated with the url of your Web Service WSDL and is
'' followed by the Web Service name
objSoapClient.ClientProperty("ServerHTTPRequest") = True
Call
objSoapClient.mssoapinit("http://system.evolucion.co.uk/evolucion-services.a
smx?WSDL")
set RecordSet = Server.CreateObject("ADODB.Recordset")
'' use the SOAP object to call the Web Method Required
RecordSet = objSoapClient.getEvolucionVersionList()
strOutput = strOutput & "<P>On-Line Result : " & RecordSet.RecordCount
================================================== ==========================
======
Adam Short写道：
Adam Short wrote:
我正在尝试编写一个连接.NET服务器的例程使用经典的ASP服务器。
我知道下面的代码不起作用！数据作为数据集返回，但ASP无法识别数据集并需要记录集。可以转换数据类型吗？
I am trying to write a routine that will connect a .NET server with a
classic ASP server.
I know the following code doesn''t work! The data is being returned
as a dataset, however ASP does not recognise datasets and requires a
recordset. Can the datatypes be converted?
编号
数据集以XML格式返回。您必须解析返回的XML文档
以提取数据。您可以使用MSXML解析器来提取您需要的节点。
Bob Barrows
-
Microsoft MVP - ASP / ASP.NET
请回复新闻组。我的From
标题中列出的电子邮件帐户是我的垃圾邮件陷阱，因此我不经常检查它。通过发布到新闻组，您将获得更快的回复。
No.
The dataset is returned as XML. You have to parse the returned XML Document
to extract your data. You can use the MSXML parser to extract the nodes you
need.
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don''t check it very often. You will get a
quicker response by posting to the newsgroup.
这篇关于经典ASP到.NET WebService接口（数据集到RecordSet）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
