how to display and retrive the two tables data into two datagirds in ado.net

For example i have one storedprocedure(name : Sp_myprocedure) then

::sp_myprocedure::

Create procedure sp_myprocedure as
begin
select * from table1
select * from table2
end

Then how to call this stored procedure and display the two tables(table1,table2) data into two data grids.

ok....Understood...if understood u got answer ..otherwise

i am leaving some code to readers like data conception,data adapter and dataset initlizations...

take two data grids ,
dg1.datasource = ds.tables[0]
dg2.datasource = ds.tables[1]

Happy ADO.NET,
Uday.Adidham