I have the same problem ... am converting a site from ASP 1.1 (VS 2003) to ASP 2.0 (VS 2005) ... In the old version I used a stored procedure with a dataadapter filling a dataset and then read from whichever table I needed. I'd love to use the new DAL with strongly typed datasets etc but it seems to focus on returning only one table at a time :(
I'd love to know if this is really the case or if I'm missing a trick somewhere!