I am having problem with displaying records in the datagrid.

If we give the following code we will be able to display records from the stored procedure.

Adodc1.RecordSource = "exec <proc_name>"
Adodc1.Refresh

Set DataGrid1.DataSource = Adodc1

But the problem is i have to execute 2 select statements and cannot combine them.

Is there any other solution. Like can i combine 2 ADO data controls
and set the datagrid's datasource.


Thanks,


monte