How do I use multiple recordsets in a VB project

Hi,
How do use multiple recordsets in a project assuming I would want to use the "NWind" Database with one connectionstring property. Also would I have to use the SQLString variable once or twice depending on the recordsets I am using? If any one has got a code to offer, I would appreciate very much. I am using ADO.

Any ideas would be wellcomed. Thanks

Albert

[This message has been edited by Albert (edited 01-24-2000).]

[Clunietp]

Are you using a data control? DAO or ADO?

[This message has been edited by Clunietp (edited 01-24-2000).]

[compuGEEK]

Assuming your using VB6, the Data Environment works very well for multiple recordsets.

------------------
CompuGEEK
cdeeble@dmagicusa.com