Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bubberz
Constraint Violating Yak Guru
289 Posts |
 Posted - 2005-11-10 : 18:48:50
|
| I need to populate 10 dropdown lists with the same SQL query. I've already tried to build three w/in the same routine, but only the first ddl is getting built.Any suggestions are welcome!Thanks! |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-11-10 : 19:39:46
|
| Pull the dataset / datatable back from the database once, and then set each drop down's datasource to the dataset / datatable.That should do it methinks....You may need to post some code so we can see what's going on.Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda> |
 |
|
|
bubberz
Constraint Violating Yak Guru
289 Posts |
Posted - 2005-11-11 : 14:18:57
|
| Thanks MichaelP!I did end up using a Dataset for all 10.I need to do some caching for these ddls, along with 20 others. There could be postbacks to the page, but the ddls will use static sprocs / datasets.Any suggestions are welcome!Thanks! |
|
|
|
|
|
|
Build 10 dropdownlists from dataset