How I can fill My DropDownList with the XmlDataSource Control in ASP.NET

Question

I want bind a xml file to my DropDownList and I want use the xmlDataSource control.

Here is my ascx code:

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="SearchControl.ascx.cs" Inherits="Telefonie.SearchControl" %>

    <div>
        <asp:Label runat="server" ID="lblSearch">Suchbegriff</asp:Label>
        <asp:TextBox ID="txtSearch" runat="server"></asp:TextBox>
        <asp:Label runat="server" ID="lblLocation">Werk</asp:Label>
        <asp:DropDownList ID="LocationDropDown" runat="server">
        </asp:DropDownList>
        <asp:Button ID="btnSearch" runat="server" Text="Suchen" 
            onclick="btnSearch_Click" />
        <asp:XmlDataSource ID="LocationDataSource" runat="server" DataFile="~/App_Data/Werke.xml"></asp:XmlDataSource>
    </div>

Here is my xml file (this xml file is in app_data folder)

<?xml version="1.0" standalone="yes" ?>
<NewDataSet>
  <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
    <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
      <xs:complexType>
        <xs:choice minOccurs="0" maxOccurs="unbounded">
          <xs:element name="resources">
            <xs:complexType>
              <xs:sequence>
                <xs:element name="Werk" type="xs:string" minOccurs="0" />        
              </xs:sequence>
            </xs:complexType>
          </xs:element>
        </xs:choice>
      </xs:complexType>
    </xs:element>
  </xs:schema>
  <resources>
    <Werk>Keine Angabe</Werk>
  </resources>
  <resources>
    <Werk>Germany</Werk>  
  </resources>
  <resources>
    <Werk>Other</Werk>
  </resources>
</NewDataSet>

I want that my DropDownList fill with this xml file but ho I can do this?

see this post will help you stackoverflow.com/questions/631365/… — Hitesh S
– Hitesh S, Commented Oct 22, 2012 at 9:27

Amol Kolekar · Accepted Answer · 2012-10-22 09:49:55Z

1

<asp:XmlDataSource ID="databasesSource" runat="server" XPath="/NewDataSet/resources" />
protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
       databasesSource.Data = [your xml];
       databasesSource.DataBind();
    }
}

edited Oct 22, 2012 at 9:49

Amol Kolekar

2,3336 gold badges30 silver badges45 bronze badges

answered Oct 22, 2012 at 9:31

L.Grillo

9813 gold badges13 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

How I can fill My DropDownList with the XmlDataSource Control in ASP.NET

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related