How to bind xml data to dropdownlist in asp.net - asp net dropdownlist xmldatasource

Asp.net dropdownlist xmldatasource: In this tutorial, I am going to show you "how to bind XML data to dropdownlist in asp.net"Mainly we fetch data from Database but sometimes as per requirement, we want to fetch data from other data source like XML(xmldatasource). Don't worry I am here to tell you how you can bind asp.net dropdown list from the XML file.

How to bind xml data to dropdownlist in asp.net - asp net dropdownlist xmldatasource
asp net dropdownlist xmldatasource


Steps to read XML file by tag name and BInd it with asp.net gridview
1. Add XML file (Visual C#).
2. Insert Data in the XML file with a specific tag. (See Below)
3. Give Server.MapPath correct.
4. Bind the dropdown with DataValueField and DataTextField.

Step 1:

Right Click on the project
-->Add
    -->Add New item
      -->Find XML File with Visual C# (See In Picture)


How to bind xml data to dropdownlist in asp.net, xml drop down
"XML drop down"


Countries.xml  (File Name)

<?xml version="1.0" encoding="utf-8" ?>
<countries>

  <country>
    <cid>1</cid>
    <cname>India</cname>
  </country>

  <country>
    <cid>2</cid>
    <cname>Pakistaan</cname>
  </country>

  <country>
    <cid>3</cid>
    <cname>USA</cname>
  </country>

  <country>
    <cid>4</cid>
    <cname>UK</cname>
  </country>

  <country>
    <cid>4</cid>
    <cname>Nepal</cname>
  </country>

</countries>




ASPX Form


<table>
        <tr>
            <td>Country :</td>
            <td>
                <asp:DropDownList ID="ddlcountry" runat="server"></asp:DropDownList></td>
        </tr>
 </table>

Code Behind File (Cs page)

       protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                Fill_Country();
            }
        }
        public void Fill_Country()
        {
            DataSet ds = new DataSet();
            ds.ReadXml(Server.MapPath("Countries.xml"));
            ddlcountry.DataValueField = "cid";
            ddlcountry.DataTextField = "cname";
            ddlcountry.DataSource = ds;
            ddlcountry.DataBind();
            ddlcountry.Items.Insert(0, new ListItem("--select--", "0"));
        }

 Thanks for reading. If you have any doubt please feel free to comment below.
Previous
Next Post »