Results 1 to 3 of 3

Thread: Binding Multiple Tables

  1. Jun 5th, 2003, 04:03 PM #1
    brianh
    brianh is offline

    Thread Starter
    Fanatic Member
    Join Date
    Oct 2000
    Location
    Seattle
    Posts
    954

    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
    Reply With Quote Reply With Quote
  2. Jun 6th, 2003, 01:45 PM #2
    Eras3r
    Eras3r is offline
    Hyperactive Member
    Join Date
    Aug 2002
    Posts
    416
    Are you reading the information from a db? Just create one huge SQL SELECT statement with JOINS.....
    Reply With Quote Reply With Quote
  3. Jun 6th, 2003, 01:55 PM #3
    brianh
    brianh is offline

    Thread Starter
    Fanatic Member
    Join Date
    Oct 2000
    Location
    Seattle
    Posts
    954
    Won't that give me a result for each instance of that ID in each table, in other words a ton of results?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width