.Net Dataset output to ADODB Recordset

[asmith555]

I have an application written in classic asp. It uses active X objects I created in VB6. I am rewriting the components in VB.Net. One of the issues I have run into is that the ActiveX component returns a ADO recordset to the asp page. I am wondering if there is a way to create an ado Recordset in vb.net to return to the asp page.

Thanks in advance

 

[RiverGuy]

If you really want to use a DATASET in .Net, but return a RECORDSET, I think it would get complicated if you wanted to do any updates. You should be able to easily declare an ADODB recordset and loop through your DataSet and add rows to it--but it would take more code to translate it back into the DataSet. If you really need to work with recordset, I would just use classic ADO and forego the ADO.Net if I were you.

 

[asmith555]

Where is the namespace for classic ADO in VB.Net

 

[RiverGuy]

I think it's ADODB. But it's not managed code. You have to add a reference to it. You do realize that no matter what, you will have to write unmanged code to return an ADODB Recordset, correct?

 

[asmith555]

I kinda figured as much. I am going to rethink this. Thanks for the help.