Binding to SqlDataSource that returns multiple datatable

[Guest]

Hello,

Stored procedure returns results of 3 different queries. On ASP.NET 2.0 page
I have a SqlDataSource control with SelectCommand equals this stored
procedure name.
I want to be able to bind 3 different controls on the page: 1 dropdown
control, 2. formview and GridView to each datatable.

Is there a way to do it? I can't find any way of doing it, other then having
3 different SqlDataSource controls for each query. But I dont want to do
that, I want to be able to resue this production sp.

Thank you for your help.

 

[Guest]

DataAdapter.Fill method will create 3 datatables out of your stored

procedure.

What abou sqlDataSource control?

 

[Eliyahu Goldin]

DataAdapter.Fill method will create 3 datatables out of your stored
procedure.