populate multiple combo boxes
Posted on 2008-11-11
i have ten combo boxes in a form. they have to be populated woth values from database.
I am using sql.i have a storeproc to get data but it has a parameter called combotype, which takes
the name of combo and fetches the result,so thisgoes on for the next nine combos.so for each
combo i am making a call to database because of which it is taking more time to populate them
so can any one tell me how can i populate multiple combo boxes with a single call to the database.
Note that to populate all the combos we use sane storeproc which has 4 params: ID,Combotype,Returnstatus,returntext