Robert,
You can load the data from the ADO recordset into an ADO.NET DataSet [0]
and pass the DataSet to the Web Service. Bear in mind that the DataSet
is an opaque (untyped) container just like the ADO Recordset. Since
loading the data into a DataSet already involves looping through the
entire recordset, you may want to consider a strongly typed solution
instead of the DataSet, if it makes sense for your application.
HTH,
Christoph Schittko
MVP XML
http://weblogs.asp.net/cschittko [0]
http://samples.gotdotnet.com/quickstart/howto/doc/adoplus/adorstodataset ..aspx
[quoted text, click to view] > -----Original Message-----
> From: Marathoner [mailto:Marathoner@discussions.microsoft.com]
> Posted At: Tuesday, December 28, 2004 9:05 AM
> Posted To: microsoft.public.dotnet.framework.aspnet.webservices
> Conversation: ADODB.Recordset as parm to Web Service
> Subject: ADODB.Recordset as parm to Web Service
>
> How can I go about transforming an ADODB.Recordset in such a way that
it's
> XML representation can be passed as a parameter to a Web Service?
>
> I have an app that consumes a Web Service. I have an ADODB.Recordset
in
> my
> app that I need to pass as a parameter to the Web Service. I know it
> cannot
> be passed in the form it is in as the recordset cannot be serialized.
>
> Robert Hill
> Senior Programmer/Analyst
> Wake Forest Univ Baptist Med Ctr