reading child tags from xml file

Question

this is my xml file. i want to fill 3 dropdownboxes 1st with countries2nd with its respective states3rd with its respective cities. in asp.net 3.5 with c# how should i do it? help me.

Bryian Tan · Answer

hello You can read the XML into a DataSet and bind the DataTable to each DropDownList separately. For instance: protected void Page_Load(object sender EventArgs e) { DataSet ds = new DataSet(); ds.ReadXml(MapPath(~/app_data/countries.xml)); BindCountries(ds.Tables[country]); BindStates(ds.Tables[state]); BindCities(ds.Tables[city]); } void BindCountries(DataTable dtblC) { ddlCountry.Items.Clear(); ddlCountry.DataSource = dtblC; ddlCountry.DataTextField = name; ddlCountry.DataValueField = id; ddlCountry.DataBind(); } void BindStates(DataTable dtblC) { ddlStates.Items.Clear(); ddlStates.DataSource = dtblC; ddlStates.DataTextField = name; ddlStates.DataValueField = id; ddlStates.DataBind(); } void BindCities(DataTable dtblC) { ddlCities.Items.Clear(); ddlCities.DataSource = dtblC; ddlCities.DataTextField = name; ddlCities.DataValueField = id; ddlCities.DataBind(); } Hope that helps. Thanks Bryian Tan