Binding a compound recordset to a Datagrid Control
Just wondering if anybody know how bind a compound recordset to datagrid control in Visual Basic 6.0.
If set the cursor location of the recordset to adUseClient and bind to the datagrid it only binds the first recordset even though there are multiple recordsets being returned from the stored procedure.
If I set the cursor location to adUseServer then I receive the "rowset is not bookmarkable" error when trying to bind to the datagrid. After this error I tried to set the cursor type to adOpenStatic, but didn't not help...