 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / ASP.NET / Web Services / December 2004ADODB.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 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 > -----Original Message----- > From: Marathoner [mailto:Marathoner@discussions.microsoft.com] [quoted text clipped - 15 lines] > Senior Programmer/Analyst > Wake Forest Univ Baptist Med Ctr Hello Marathoner, Try this article http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/bdad otnetwebservice1.asp HTH Regards, Dilip Krishnan MCAD, MCSD.net dkrishnan at geniant dot com http://www.geniant.com > 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? [quoted text clipped - 7 lines] > Senior Programmer/Analyst > Wake Forest Univ Baptist Med Ctr
Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.