Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

Populate drop downlist with an xml file

Anonymous User 2400 20 May 2013

Hi Developers,

I have two dropdownlist in my app country and state and i have to populate them through an xml file.

I have written the following code:

ds = new DataSet();

ds.ReadXml(Server.MapPath("~/country_state.xml"));

LoadCountryDropdownList();

public void LoadCountryDropdownList()

{

ddlCountry.DataTextField = "name";

ddlCountry.DataValueField = "country_Id";

ddlCountry.DataSource = ds.Tables["country"];

ddlCountry.DataBind();

LoadStateDropdownList(ddlCountry.SelectedValue);

}

private void LoadStateDropdownList(string country_Id)

{

}

through this code i have achieved data reading from an xml file is done

and i have also populate the country dropdownlist list

now i have to populate the state dropdownlist list on the basis of country dropdownlist.

Thanks in advance.

Ask by Anonymous User

Updated 20 May 2013

1 Answers

Sumit Kesarwani 20 May 2013

Hi Jacob,

try this code in your app

ddlState.DataTextField = "state_Text";

DataView dv = new DataView(ds.Tables["state"]);

dv.RowFilter = "country_Id = " + country_Id;

ddlState.DataSource = dv.ToTable();

ddlState.DataBind();

I hope this code will solve your problem.

MindStick Training

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.