Hi everybody, I posted the original topic in other forums and solutions they provided involves using .Net Framework 2.0. i am using .Net framework 1.1. Trying to avoid using a lot of sql access (Select Distinct statement execution) and a lot of loop execution. Do anyone knows another way to solved this problem? Thanks in advanced.Original Post: Hi everybody, I like to asked anyone who is very good at sql to help me display this data in a table format that duplicate headings, subheadings or other columns won't appear twice or more. Can anyone help me? I need to sort them and load them in a Datatable. Loop thorugh all records and display them in a label control created at run time. Thanks in advance.
Sample Data:
Topics TableTopicId TopicLevel Topic ParentId1 1 First 02 1 AnotherFirst 03 2 Second 14 2 AnotherSecond 25 3 Third 3
Contents TableContentID Heading SubHeading SubSubHeading1 NumberText Names Content1 ParentId1 How are you? Hello Someone 1 Ben some text 52 How are you? Hello Someone 1 John other text 53 How are you? Hello Anybody 2 Ben some text 54 How are you? Hello Anybody 2 Mike other text 55 How are you? Greet Anywhere 1 Ben some text 56 How are you? Greet Anywhere 1 Luke some text 57 I miss you. Really When null null some text 58 I miss you. Really When null null some text 5
Display Format: How are you?---------------------------------------------- Hello-----------------------------------------------1 Someone ---------------------------------------------- Ben some text--------------------------------------------- John other text---------------------------------------------2 Anybody--------------------------------------------- Ben some text--------------------------------------------- Mike other text-------------------------------------------- Greet------------------------------------------------- 1 Anywhere----------------------------------- Ben some text------------------------------------- Luke some text================================================ I miss you-------------------------------------------------- Really------------------------------------------------ When----------------------------------------------- some text---------------------------------------- some text------------------------------------------
Dennis