Binding Multiple Tables

Hello all,

I need to create a summary page for an ASP application. The page will be the results of about 30 tables with one common indentifier (locationID). I heard that asp.net does a wonderful job with taking massive amount of data in one connection. How would I bind each table to its own datagrid but only return the proper location ID (I will get that using request.querystring)?

Brian

Are you reading the information from a db? Just create one huge SQL SELECT statement with JOINS.....

Won't that give me a result for each instance of that ID in each table, in other words a ton of results?