is there any way to reduce time required to retrrive whole data from database and adding it to listview control.
i am having records about 3500 from 1 tables and for for each record it search for record in 2nd table and depending on 4to 5 conditons, i have to make color of each record dispalyed in list view control as diffrent color.
my database is in access and located on server.
it takes much time.
can you help me to reduce time ?