POPULATE DROP DOWNLIST WITH AN XML FILE

jacob rasel

Total Post:88

Points:616
Posted by  jacob rasel
 1191  View(s)
Ratings:
Rate this:
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.
  1. Sumit Kesarwani

    Post:378

    Points:2694
    Re: Populate drop downlist with an xml file

    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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!