can a datagrid display records from 2 separate ADO Data Controls

[monte]

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

[PsudoLogical]

Yes you can, but it involves returning queries to recordset objects and manually assigning the values to the cells in the grid... can get kinda messy if it is a large number of items...

I'll try to see if there is any other way, but your idea will work in a pinch

Hope this helps!