dual drop down same datareader Opinions..

[Zarcom]

Got an opinion question here and I would like to hear your opinions on it.

I have a datareader returning data based on a stored proc. Thing is that I can use the information in that reader to fill two drop down boxes. You cannot do this with one reader since when you do a databind it closes the reader.

So I have thought of two options.
1. I could go grab the data twice from the database and bind the drop downs separately.
2. I could throw the data into a collection and bind the two drop downs from there.

your opinions on my two options or new ideas are appreciated thanks.

That'l do donkey, that'l do
Mark
If you are unsure of forum etiquette check here faq796-2540

 

[juliaroberts]

I would go for a collection as fetching again from the database doesn't go to well with performance. Maybe you can use a dataset, which can be assigned as datasource to both drop downs.