no .. the list will not always populate 100000 records.
i have provided two combos.. first one to select the medicine and the secod one is for manufacturer. All this two combos have an element captioned "<All> ".
so . some users may select both combos with value <All> ,then select the seach button.

As i already discussed, its working fine in vb6 with ADO. and what i am wondering is ,why it is not in vb.Net. AFIK, ADO.net must have better performance than ADO. right ?. Since i am new to ADO.Net , i need to clarify the performance lag is due to my coding style or not, and need to know how i can able to get the maximum performance... atleast upto ADO can deliver.

Thanks & regards.