Welcome to weblogs.com.pk Sign in | Join | Help

Converting Dataset into Recordset

Here's an interesting scenario, that my colleague was trying to sort-out today

I have couple of web services built using Microsoft.NET which returns DataSet.

The .NET clients are working fine, now I want two other applications to use these web services. One is Classic ASP (ASP3) based and other is PHP (4.x) based.

Any ideas how those two applications can consume my webservices and handle datasets? More specifically, can I convert dataset into ADODB recordset?

 

I have built .NET based proxy library, using interop the dataset is converted into ADODB recordset, but there are three bottle-necks.

  • I haven’t found any way to convert dataset into recordset directly, I am transforming dataset xml into recordset-friendly xml using XSL, write that output into a file and then open a recordset from that file
  • .NET proxy uses ADODB primary inter-op assembly
  • .NET library is exposed to COM clients (ASP and PHP) using CCW

Is there any better alternative than what I have done?

Published Wednesday, August 10, 2005 8:19 PM by khurram
Filed under: ,

Comments

# re: Converting Dataset into Recordset

Thursday, August 11, 2005 1:46 PM by kadnan
this might help you,as mentioned,webservices are nothing but XML,check this out

http://www.devcity.net/articles/29/1/20020331.aspx

# re: Converting Dataset into Recordset

Sunday, August 14, 2005 4:42 PM by Khurram
Hi Khurram!
Web services all about distributed world, where we dont have defined clients. Web services all about providing software as services so any other application would be able to use it. Web services designing best practices are very different than design tradional windows or web application. Generally we dont expose Datasets to external world as it is. MSDN online library contains awesome articles on exposing datasets to external world. You can navigate page http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnservice/html/service02112003.asp
The following links contains very usefull information regarding web services interoperability.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/dotnetinteroperability.asp

http://msdn.microsoft.com/msdnmag/issues/03/04/XMLFiles/default.aspx

If you still faild to design a sopisticated solution please let me know. I would be happy to listen about your purposed solution.

# Enterprise Applications and InterOp

Thursday, August 18, 2005 6:39 PM by Khurram Aziz
I posted few days back about converting .NET Dataset into ADODB Recordset.
Here is the deployment diagram...
New Comments to this post are disabled