veronica86
Member
I want to user a repeater to display the results in my dataset. I am joining 2 tables. ex)
table 1
******
NAME CITY
Fred ElPaso
table 2
******
NAME LANGUAGES_SPOKEN
Fred German
Fred Latin
Fred English
So my dataset looks like this after joining the 2 tables on NAME:
Fred ElPaso German
Fred ElPaso Latin
Fred ElPaso English
I want my repeater to display the results like this:
Fred ElPaso
German
Latin
English
I am binding labels to the results, but I can't figure out how to display only the first row in the dataset, so that I only display the NAME and CITY once!
Any ideas would be greatly appreciated! Thank you
table 1
******
NAME CITY
Fred ElPaso
table 2
******
NAME LANGUAGES_SPOKEN
Fred German
Fred Latin
Fred English
So my dataset looks like this after joining the 2 tables on NAME:
Fred ElPaso German
Fred ElPaso Latin
Fred ElPaso English
I want my repeater to display the results like this:
Fred ElPaso
German
Latin
English
I am binding labels to the results, but I can't figure out how to display only the first row in the dataset, so that I only display the NAME and CITY once!
Any ideas would be greatly appreciated! Thank you