Possible to "select" from a sqldatasource?

I'm still learning how to use sqldatasource and have a question.
I have a sqldatasource associated with a gridview.  I'd like to be able to query against the "result set" of the sqldatasource. Does there exist a temp table for the sqldatasource that I can use in another query?  If there is already a temp table, I'd like to be able to use it.  Does anyone know if this is possible, and if so, how to do it?  Or alternatively, how to select the sqldatasource into a temp table?

(I know how to iterate through each row of the dataview to get the column value I need  as a parameter in a related query.  However, rather than issuing one query per row, I'd like to make a temp table and use it in  a join in my related query , so that I execute the related query just once.  Before I write code to manually create the temp table, I thought I'd ask to see if one already exists,)