dropdown list problem

Question

hello i am facing few problems of using dropdown list. there is a dropdownlist with few items like:- allabcdefxyz my problem is that by default whenever page loads it shows record for all but whenever i just select other item say abc or xyz; it does not display its respective records in gridview. i just want to select any other item from dropdown and it should have to display its respective record without clicking any button. and 1 more thing when the data will display according to dropdown item selection; i can perform edit/delete/add operation only there in gridview. so please tell me the solution. thank you.

Priyank Khare · Answer

hello yes i am using:- if(!IsPostBack) { populate dropdownlist } at page load i am sending you my code:- protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { ddldata(); if (Request.QueryString[Fid] != null) { faciltity(); } else { BindData(); } } } public void ddldata() { SqlConnection con = new SqlConnection(Server= + ConnectionServer + ; + sConn); con.Open(); SqlCommand cmd = new SqlCommand(select hotel_name from HotelMaster  con); SqlDataReader Reader = cmd.ExecuteReader(); while (Reader.Read()) { DropDownList3.Items.Add(Reader[0].ToString()); } DropDownList3.Items.Insert(0 All); con.Close(); } public void BindData() { SqlConnection con = new SqlConnection(Server= + ConnectionServer + ; + sConn); con.Open(); SqlCommand cmd; if (DropDownList3.SelectedItem.Text == All) { cmd = new SqlCommand(select Fidhotel_nameFacilityTypeFacilityNameDescriptionActiveFlagInsertedByUpdatedBy from Infl_HotelInventory_Facility con); } else { cmd = new SqlCommand(select Fidhotel_nameFacilityTypeFacilityNameDescriptionActiveFlagInsertedByUpdatedBy from Infl_HotelInventory_Facility where hotel_name=' + DropDownList3.SelectedItem.Text + ' con); } DataSet dst = new DataSet(EmpDs); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dst Infl_HotelInventory_Facility); GridView1.DataSource = dst.Tables[0]; GridView1.DataBind(); con.Close(); } please help me to solve my problem. thank you

Nattudurai Eswaramurthy · Answer

Hi The problem is when ever the page loads ur drpdown list control fills the data again in Page load. Use the following code: if(!IsPostBack) { mydropdownlist.datasource = Soure; } this above statement prevent u from loading data to ur drpdown list. Hope this will resolve ur issue

Abhijit barua · Answer

do u use if(!IsPostBack) { populate dropdownlist } at page load