How to bind my DDL from XML Data Source in asp.net

Question

I have a xml file which is given to me by client so i can't change it it looks like this:

CodeBase.XML

<?xml version="1.0" encoding="utf-8"?>
<CATALOG>
  <orderByTitleDesc />
  <orderByTitleDesc />
  <orderByTitleDesc />
  <orderByTitleDesc />
  <orderByTitleDesc />
  <CD>
    <CodeBase>hellow</CodeBase>
  </CD>
  <CD>
    <CodeBase>http://KL1225K7/EViewer/Client/EvCtrl6En.cab#version=9,4,2,9</CodeBase>
  </CD>
  <CD>
    <CodeBase>31 amrch testing for font</CodeBase>
  </CD>
  <CD>
    <CodeBase>CodeBase2</CodeBase>
  </CD>
  <CD>
    <CodeBase>Ser</CodeBase>
  </CD>
  <CD>
    <CodeBase>ZaidiTest</CodeBase>
  </CD>
  <CD>
    <CodeBase>test222</CodeBase>
  </CD>
</CATALOG>

I want to bind this xml with this in ddl

I am writing the code in code behind file as follows:

 protected void Page_Load(object sender, EventArgs e)
    {

        string filePath = Server.MapPath("CodeBase.xml");
        using (DataSet ds = new DataSet())
        {
            ds.ReadXml(filePath);
            ddlCodeBase.DataSource = ds.Tables["1"];
            ddlCodeBase.DataTextField = "CodeBase";
            ddlCodeBase.DataValueField = "CD";
            ddlCodeBase.DataBind();
        }
    }

Client side code as Follows:

 <asp:DropDownList ID="ddlCodeBase" runat="server" ></asp:DropDownList>

But i am getting empty DDl (No data in it). Please Let me know Guys what to do. Thanks in Advance.

Possible duplicate of How I can fill my DropDownList with Data from a XML File in my ASP.NET Application — Uali
– Uali, Commented Jul 20, 2016 at 5:07

Surajghosi · Accepted Answer · 2016-07-20 05:13:11Z

0

Try below code . its working fine for me.

 string filePath = Server.MapPath("~/Cities.xml");
using (DataSet ds = new DataSet())
{
    ds.ReadXml(filePath);
    ddlCities.DataSource = ds;
    ddlCities.DataTextField = "CodeBase";
    ddlCities.DataValueField = "CodeBase";
    ddlCities.DataBind();
}

answered Jul 20, 2016 at 5:13

Surajghosi

2261 gold badge2 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Basant Gera Over a year ago

When I Debug till Last in gives me Error like this An exception of type 'System.Web.HttpException' occurred in System.Web.dll but was not handled in user code Additional information: DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'CodeBase'.

Surajghosi Over a year ago

Change file name i used cities.xml

Basant Gera Over a year ago

protected void Page_Load(object sender, EventArgs e) { //fillDDL(); string filePath = Server.MapPath("~/CodeBase.xml"); //using (DataSet ds = new DataSet()) //{ DataSet ds = new DataSet(); ds.ReadXml(filePath); ddlCodeBase.DataSource = ds.Tables["CD"]; ddlCodeBase.DataTextField = "CodeBase"; ddlCodeBase.DataValueField = "CodeBase"; ddlCodeBase.DataBind(); // } }

Basant Gera Over a year ago

By Adding this to my Code ddlCodeBase.DataSource = ds.Tables["CD"];

Surajghosi Over a year ago

if my code helpful for you then voted me .@BasantGera

Collectives™ on Stack Overflow

How to bind my DDL from XML Data Source in asp.net

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related