Add Xml Datasource to gridview DropDown list

HI friends ,In this article i would like to explain "how to bind XML Datasource to Dropdown list" just follow the steps clearly

First we need to create a XML file to store the data.suppose you would like to store contries data in xml file and bind that data to Dropdown list

Step 1:Add new Xml file to your existing Aspnet project

Step 2:copy the following code in to XML file

<?xml version="1.0" encoding="utf-8" ?>
<Countries>
  
  <Country name="India" value="1"></Country>
  <Country name="America" value="2"></Country>
  <Country name="France" value="3"></Country>
  <Country name="Saudi" value="4"></Country>
  <Country name="Srilanka" value="5"></Country>
</Countries> 

Step 3:save the file with countries.xml

Step 4:now open the page which contains Gridview

Step 5: Now add the following code for your gridview.In the below code , i am added One Xml datasource which is available in our Toolbox.just Drag and Drop the  Xml datasource.then just add the Datasource ID of the drop downlist

<asp:TemplateField HeaderText="DOB">
  
<ItemTemplate>

<asp:Label ID="lbl_ct"  runat="server" Text='<%# Bind("country")%>'>>

</asp:Label>

</ItemTemplate>

<EditItemTemplate>

<asp:DropDownList ID="ddl_ct" AutoPostBack="True" 
DataTextField="name" DataValueField="value" runat="server" 
AppendDataBoundItems="True" DataSourceID="countries" 
SelectedValue='<%# Bind("country", "{0}") %>' >
</asp:DropDownList>

  <asp:XmlDataSource ID="countries" runat="server" DataFile="~/XmlDataSource/countries.xml">

</asp:XmlDataSource>

</EditItemTemplate>

</asp:TemplateField>

Success....Now the data will displayed in the Drop down list

Thats it...

About the Author

Sayyad is a Software Engineer, Blogger and Founder of Developers Code from India.His articles mainly focus on .Net (Web and Windows based applications), Mobile Technologies (Android,IPhone,BlackBerry) and SEO.

Reach Him :

Google+

Facebook

Twitter

Pinterest