Please Help me out

[monte]

I am having a problem with displaying data in a datagrid .

I am using ADO data control where i am using stored procedure
having 2 select statements. when i try to set ADO datacontrol to the datagrid i am getting only the records from the first select statement.

Can anyone help me with getting records from both the select statements be displayed in the data grid.

Thanks,
Monte.

[ShIzO]

you have two select statements in one store procedure?
i guess that when you run it, it shows one after another?

if so why are you doing it this way? can you combine them?

store procedure should always return one recordset...