Groups | Blog | Home
all groups > asp.net webservices > december 2004 >

asp.net webservices : ADODB.Recordset as parm to Web Service


Marathoner
12/28/2004 7:05:04 AM
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
Dilip Krishnan
12/28/2004 7:28:43 PM
Hello Marathoner,
Try this article http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/bdadotnetwebservice1.asp

HTH
Regards,
Dilip Krishnan
MCAD, MCSD.net
dkrishnan at geniant dot com
http://www.geniant.com

[quoted text, click to view]

Christoph Schittko [MVP]
12/28/2004 9:04:46 PM
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]
AddThis Social Bookmark Button