What?? Disconnected recordset?

[jeba]

Hi there!

I am in the process of porting a huge ASP application to ASP.NET. In most of the ASP pages, I have used a COM component to retrieve a ADO disconnected recordset. (This way, I have avoided opening connection in ASP pages).

Now, I am willing to port COM components into .NET components. In that regard, I want to rewrite my components to use ADO.NET. However I couldn't find any object to replace the 'disconnected readonly ADO recordset' in ADO.NET. I know I can use DataReader, but that is 'connected' to the DB & hence I would prefer not to use that.

Can you please tell me is there anyway I can return a disconnected recordset (or anyother similar object) to ASPX pages, from which I can loop thru' the recordset & do other HTML stuff?

Thanks,