I have an old dll (written in VB) that I want to use with my ASP.NET pages. It basically takes an SQL SELECT command and executes it against a database, and returns a recordset. Being new to .NET I am wondering how I can use this in my ASP.NET project? Do I just need to add the reference to it? Then how do I handle the returned recordset?

____________________________
Eggheads unite! You have nothing to lose but your yolks.

I think I have this figured for the most. I believe I can "Fill
" a DataSet with the Recordset in .NET. This should work though I havent gotten that far yet.

Also, I believe I can use my older techniques in handling the recordset in .NET...so I should be OK...

Please correct me if I'm wrong and if anyone has any data handling suggestions I am all ears...

____________________________
Eggheads unite! You have nothing to lose but your yolks.

Maybe you should rewrite your code from scratch, since I believe it is not a good tehnique to mix ADO and ADO.NET. In ADO.NET dataset is filled using data adapter. So, in my opinion, if you first load data in recordset, and then fill dataset using recordset, it will double the ammount of time to get data, and should be avoided.

____________________________
If you find the answer helpful, please mark this topic as solved.

I agree with Goran here. I think a rewrite of your dll as a component and then putting up perhaps as an assembly
. Microsoft have stopped support for any VB.OLD stuff.
This will get you upto speed with ADO.NET and perhaps you could make it a reusable component and perhaps post it here for others to use  

____________________________
BrainBench ADO.NET and ASP.NET Certified Developer