Problem in country state dropdownlist

Question

0.00/5 (No votes)

See more:

Hi,
I had problem in populating country and state dropdownlist.The problem is,

1. I had binded countrytable dropdown with country table
2. To get related state of a country I wrote code like

<code>
public void ddlCountry_SelectionChanged(object sender, EventArgs e)
{

AddressBookDataContext dc = new AddressBookDataContext();
DropDownList ddlFkCountry = (DropDownList)fvAddress.FindControl("ddlFKCountryId");
DropDownList ddlState = (DropDownList)fvAddress.FindControl("ddlFKStateId");
int countryId = Convert.ToInt32(ddlFkCountry.SelectedValue);
List&amp;lt;State&amp;gt; lststate = dc.States.Where(p =&amp;gt; p.FKCountryId == countryId).ToList();
ddlState.DataSource = lststate;
ddlState.DataTextField = "StateName";
ddlState.DataValueField = "PKStateId";
ddlState.DataBind();
}
</code>

3. Its working Iam getting the output. Im getting the related state of a country.

4. Here comes the problem as im executing, As soon as the form is opened(when the page is opened) it is not displaying the related state of a country it is showing empty dropdown. When I select any other country in dropdownlist then only it is displaying the relating state.

My requirement is as im executing the code the state also should be shown with the related country.

Regards,
Grace.

Posted 20-Sep-10 21:36pm

Susan Marampudi

Add a Solution

Comments

demouser743 21-Sep-10 4:12am

Did you write a query regarding that you need. As per my understanding you need to display state related to country right.

eslam soliman 21-Sep-10 8:49am

i think that it is normal that is why the drop dawn list have to do post back may be you can bind the state ddl with a default value that is related to the first element in country ddl and when you select another country do your post back and bid the state ddl with the new values

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)

m@dhu · Answer 1 · 2010-09-20T21:56:00

Solution 1

you need to populate the statedropdown and call the method(same code as in ddlCountry_SelectionChanged) in page load event..

Posted 20-Sep-10 21:56pm

m@dhu

NMehta83 · Answer 2 · 2010-09-21T02:01:00

protected void Page_Load(object sender, EventArgs e)
{
AddressBookDataContext dc = new AddressBookDataContext();
DropDownList ddlFkCountry = (DropDownList)fvAddress.FindControl("ddlFKCountryId");
DropDownList ddlState = (DropDownList)fvAddress.FindControl("ddlFKStateId");
ddlFkCountry.SelectedIndex = 0; 
int countryId = Convert.ToInt32(ddlFkCountry.SelectedValue);
List<state> lststate = dc.States.Where(p => p.FKCountryId == countryId).ToList();
ddlState.DataSource = lststate;
ddlState.DataTextField = "StateName";
ddlState.DataValueField = "PKStateId";
ddlState.DataBind();
}

kaushal s · Answer 3 · 2010-09-22T04:40:00

you can also place 'Select Country' and 'Select State' at Row Index -1.

So that on Page Load Both dropdown will contain 'Select' and the moment

user changes dropdown your SelectedIndexChanged Event Will fired

DropDownListState.Items.Insert(-1, new ListItem("Select Country",""));
DropDownListState.Items.Insert(-1, new ListItem("Select State",""));

Problem in country state dropdownlist

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0