Clever Geek Handbook

Return ADODB.Recordset type from .NET to Classic ASP

I have a DAL that I want to return ADODB.recordset when executed from classic asp. The object is exposed as a com object and I have a complete dal working, but I'm not sure how to return an object, which is a recordset that .net can use.

Any help would be appreciated. Thank!

- Nicholas

0


source to share


3 answers


I think you both are for your feedback, but what I was looking for was probably misunderstood due to a poorly written question. I found a link to a page that did exactly what I was looking for.

I have a DAL, which is an assembly that I would like to open ASP, but to do so, in order not to rewrite a lot of code, I had to first find a way to return the recordset type ONLY when from classic ASP applications. This will result in a VIA call to the COM method that will invoke the DAL call and convert the returned .NET DataSet as a VB RecordSet.

Here is the link I found that made this possible. http://www.codeproject.com/KB/database/ADOConversion.aspx



Once again, thanks for your help and your input, and I apologize for such a poorly written question.

- Nicholas

+1


source


You need to add a reference to the underlying ADODB COM to your web project along with a reference to your DAL component. Then you have to use the component in the same way as in ASP.

Having said that, you should read this KB: -



KB312111

I highly recommend that you migrate your DAL to a .NET assembly first.

+1


source


Same as Anthony said, if you can avoid it, by all means. If your DAL is a very generic DAL, you can easily write it in .net or use someone like Application Block and spend less time than problems that might arise.

0


source






More articles:


All Articles