I have a user control with a very basic table structure. The data is split by three types...B,U,C. The output I'm looking for is:
Title A
Data for rows - type B & C, 1 row per table cell
Title B
Data for rows - type U, 1 row per table cell
There will not always be both C & U data, so if both arent there, it should only show the first or last half of the above. I was wondering if there would be a way to only use one repeater and one dataset to get the above results, instead of having two repeaters and 2 sql calls. Can filters be used in some way? Or something else?
Using 2 repeaters with 1 dataset that retrieves all 3 types. Then creating 2 views filtering by type.