dropdownlist

prisilla jayaraj

15y2.6k.NET

i add the data from database to my dropdownlist,when everytime i refresh the page the same items added repetedly

like mango
graphes
orange
mango
graphes
orange
if i set property append data bound-false some things are not work properly
how could i avoid that issue?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

15y ago
You have to add all the items only once correct, so you have to handle "ISPostBack" property of the Page.

So in the Page_Load event

protected void page_Load(object sender,EventArgs e)
{
if (!IsPostBack)
{
//Load your dataset or datatable here.
//Bind the DropDownList here.
}
}

Hope this helps you.
0
Suthish Nair15y ago
How you adding the records, can you share the code..

On Page_Load

protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
DataSet ds = new DataSet();
ds --> fetch records into DataSet from database

dropdownlist1.DataSource = ds.Tables[0];
dropdownlist1.DataTextField = "State";
dropdownlist1.DataValueField = "StateId";
dropdownlist1.DataBind();
dropdownlist1.Items.Insert(0, "Select");
dropdownlist1.SelectedIndex = 0;
}
}

0
Felipe Ramos15y ago
You need to check where you are adding the items. If that code is running more than once you would get that behavior.

In your page load you will need to add

if (!Page.IsPostBack)
{
// Add it here
}
0