Filling multiple dropdowns while page loading

[chhatra]

I have 8 dropdowns to be filled from database .
To avoid roundtrips to the database what i should use?

[prabunewindia]

you can use

if(! IsPostBack)
{
// code to fill dropDownBox;
}

so u can avoid round trips to database after page loaded once
Prabu

I have 8 dropdowns to be filled from database .
To avoid roundtrips to the database what i should use?

[gomzi]

I have 8 dropdowns to be filled from database .
To avoid roundtrips to the database what i should use?

use Atlas.

[vidhyapriya]

Use DISTINCT in ur query

EX:select DISTINCT name from Table1

[ummaria]

You can try the PreRender()

[Frinavale]

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

[vivekshrivastava51]

first u create a methosd like that for all dropdown list

and then call then them in page load method
that is automaticaly dowload at the at the loading of page

if(!IsPostBack)
{
//call drop down list method
}

[dwadish]

first u create a dataset object
then select columns from table using sqldataadapter and fill it to the dataset

write code for displaying first dropdownlist
use the databind()
use these to all of ur dropdownlistbox
and binding method also

retry now