I have to display some information similar to a nested gridview or master detail look and feel...
I have a gridview binded to my bll method to display some ID's for me from the database.That works fine. I need to take those ID's from that gridview and run each of them against another query.I have 2 tables, Quote_Header, Quote_Lines.
Quote_Header :- stores the quote information like account number, date created and the primary key is QUOTE_REF and this is auto-incremented. (all this works fine)Quote_Lines :- stores the items for the quote, like product ID, qty and line total and the primary key is QUOTE_LINE_ID, the foriegn key is QUOTE_REF,
so i know would items belong to which quote. I have another gridview which displays the QUOTE_REF's.I want to loop through this gridview and display QUOTE_HEADER information and below that QUOTE_LINE information and then again QUOTE_HEADER information and below that QUOTE_LINE information for the next ID.
So I am using a loop but its not working. I want it to display like below.
Quote Ref :- 35 Account :- 2052641 Date Created :- 02/02/2010 ----Quote_Line ID :- 1 Product :- Laptop Qty :- 25 Quote Ref :- 35 ----Quote_Line ID :- 2 Product :- Microwave Qty :- 5 Quote Ref :- 35 ----Quote_Line ID :- 5 Product :- TV Qty :- 2 Quote Ref :- 35
Quote Ref :- 36 Account :- 20452641 Date Created :- 02/02/2010 ----Quote_Line ID :- 33
View Complete Post