I am returning multiple recordsets from a SQL stored procedure, and using the ADO NextRecordset method to retrieve all of them into my VB app. Does anyone know if there are any problems created by passing too many recordsets back this way?? I am passing 7 recordsets back from one proc (I'm populating a form, there are a bunch of combo boxes to populate). Is it better to pass more back this way, or to hit the database multiple times for fewer recordsets. The recordsets are mostly pretty small.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Passing multiple recordsets
- Thread starter alanf
- Start date
Similar threads
- Locked
- Question
- Locked
- Question