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

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

The14thNoah · Answer 1 · 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 :)

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.

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

Solution 1

Please try This...

link1

Posted 9-Feb-14 21:29pm

OPees

drop down list concerns

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0