I have 8 dropdowns to be filled from database .
To avoid roundtrips to the database what i should use?
You could fill a dataSet or some other object with the information gathered from the database on the first trip to the website, then store this object into session.
You can just use the object stored in session to fill your dropDownLists instead of having to grab the information from the database every time...
This will work unless you need up-to-date data from the database every time the user posts back. Then I don't think there's a way around it.
-Frinny