how to remove duplicate item in Listview item ??

i have a listview and i need to remove the duplicate data that i get from the database

how can i remove the duplicate item at the listview ???
:(

if you have dups in your database the only way to remove them on the fly is to group the data

GROUP BY FieldName

sorry

is there any other idea ?

thanx

if the dups are in the database then clean the database

sorry

is there any other idea ?

thanx

What answer do you want ?

If you have duplicate records within the database then surely its a bad database administration issue. Duplicate records shouldnt really occur for many reasons.

Or is it just the case your not clearing the listbox each time its loaded