drop down list concerns

Question

1.00/5 (1 vote)

See more:

I have two drop down lists as DDL1 & DDL2. I have 3 items in DDL1, where the 1st item is --SELECT--. When I select the 22nd item in DDL1, the items of DDL2 gets populated from the database. But the problem is, when I select the --SELECT-- item in DDL1, the item which was previously selected in DDL2 remains as it is and does not removes.I want that when ever i select --SELECT-- in DDL1, DDL2 should get empty & when I select 1st or 2nd item from DDL1, then DDL2 should get populated from the database. Can any one please help ?

Posted 9-Feb-14 20:50pm

Member 10520129

Add a Solution

Comments

Kornfeld Eliyahu Peter 10-Feb-14 2:55am

Have you done anything so far? Show some effort (code or searching)! As is it ain't a question...maybe a homework one...

Member 10520129 10-Feb-14 3:15am

I am posting a portion of my coding..

public void FillActivityWaterStorage()
{
try
{
dt = Query.Guindy_ActivityWaterStorage_Population();
if (dt.Rows.Count > 0)
{
ddl_ActivityWaterStorage.Items.Clear();
ddl_ActivityWaterStorage.DataTextField = "ActivityName";
ddl_ActivityWaterStorage.DataValueField = "ActivityID";
ddl_ActivityWaterStorage.DataSource = dt;
ddl_ActivityWaterStorage.DataBind();
ddl_ActivityWaterStorage.Items.Insert(0, new ListItem("--SELECT--"));
}
else
{
ddl_SubActivityWaterStorage.Items.Insert(0, new ListItem("--SELECT--"));
}

}
catch
{
}
}

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OPees · Answer 1 · 2014-02-09T21:29:00

Solution 1

Please try This...

link1

Posted 9-Feb-14 21:29pm

OPees

Md.Sajidur rahman · Answer 2 · 2014-02-09T21:35:00

You need to do it on SelectedIndexChanged Event.

C#

protected void ddlSparte_SelectedIndexChanged(object sender, EventArgs e)
    {
 DataRow dr = dt.NewRow();
            dr["Produktname"] = "...SELECT...";
            dr["Produkt_id"] = "0";
            dt.Rows.InsertAt(dr, 0);

            ddlProdukt.DataSource = dt;
            ddlProdukt.DataTextField = "Produktname";
            ddlProdukt.DataValueField = "Produkt_id";
            ddlProdukt.DataBind();

}

Please change your dropdownlist and others. Its just a concept.

The14thNoah · Answer 3 · 2014-02-09T21:40:00

this is your previous code:

public void FillActivityWaterStorage() 
{ 
  try 
    {  
    dt = Query.Guindy_ActivityWaterStorage_Population(); 
      if (dt.Rows.Count > 0) 
             {
               ddl_ActivityWaterStorage.Items.Clear(); 
               ddl_ActivityWaterStorage.DataTextField = "ActivityName";      
               ddl_ActivityWaterStorage.DataValueField = "ActivityID";  

               ddl_ActivityWaterStorage.DataSource = dt; 
               ddl_ActivityWaterStorage.DataBind();
               ddl_ActivityWaterStorage.Items.Insert(0, new ListItem("--SELECT--")); 
             } 
       else 
             { ddl_SubActivityWaterStorage.Items.Insert(0, new ListItem("--SELECT--"));
             } 
       } 
    catch { } 
 }

you do work around here. . . add item in your DropDownList2 jsut like you did in dropdownList1

ddl.Items.Insert(0,"--");//just like this(optional if the code below dont work)

now for the ddl selected changed:

public void ddl_ActivityWaterStorage_SelectedChanged(Sender object,EventArguments e)
{
 if(ddl_ActivityWaterStorage.SelectedValue==The2nditem)
   {
    ddl_SubActivityWaterStorage.DataSource=PopulateDataFromDatabase;
    ddl_SubActivityWaterStorage.DataBind();
   }
 else
  {
   ddl_SubActivityWaterStorage.DataSource=null;
   ddl_SubActivityWaterStorage.DataBind();
  }

}

hope it will work,comment if got error or something wrong so I can check the code again :)

drop down list concerns

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

drop down list concerns

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us