I got a dataset which contains the following data:
id code description eff_date end_date
---------------------------------------------------------
1 ADV ADVANCE 2007-12-01 2007-12-31
2 ADV ADVANCE 2008-01-01
3 BUS BUS TICKET 2005-03-09 2007-04-05
4 BUS BUS TICKET 2007-04-06
5 PET PETROL FEES 2008-01-02 2009-10-11
6 PET PETROL FEES 2009-10-12
7 BOK BOOK 2010-01-01
Now if I want to display all records in a ListView but I don't want to display two records with the same code, that means the output should be like this:
ADV ADVANCE
BUS BUS TICKET
PET PETROL FEES
BOK BOOK
how??
Thanks first...