populate multiple combo boxes

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

Who is Participating?
Anurag ThakurConnect With a Mentor Technical ManagerCommented:
make sure that your stored procedure returns 10 different tables back - in the single db call - in the dataset and each table contains the data which needs to be bound in the each combobox -

assuming that you have got the result set (10 tables) then you can do a databind for the combo with different table in the dataset and do a databind and thus you can get your result set in a single db call
Do you want to populate all the combo boxes with the same set of values? Which column of the query you are filling in the Combo Box?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.