Editable GridView with Complex XML as DataSource

Divya Maheswari Kiyanuru

10y769.NET

Hi,

I have an requirement for editable XML. So for that i need to get the data from XML file which is complex data with multiple nested table set to gridview.Can any one help me .

Thanks in Advance

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

<Countries>

   <Country>

        <CountryName>AustraliaCountryName>

Melborn

1

Crawley

2

        <LabelABN>ABNLabelABN>

        <TextBoxLimitABN>14TextBoxLimitABN>

        <LabelACN>ACNLabelACN>

        <TextBoxLimitACN>14TextBoxLimitACN>

    Country>

    <Country>

      <CountryName>PakistanCountryName>

      <LabelABN>NTNLabelABN>

        <TextBoxLimitABN>20TextBoxLimitABN>

        <LabelACN>BNumberLabelACN>

        <TextBoxLimitACN>22TextBoxLimitACN>

    Country>

    <Country>

      <CountryName>IndiaCountryName>

        <LabelABN>NTTLabelABN>

        <TextBoxLimitABN>18TextBoxLimitABN>

        <LabelACN>IDPLabelACN>

        <TextBoxLimitACN>24TextBoxLimitACN>

    Country>

Countries>

3 Replies
Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Sign inCreate an account

Bikesh Srivastava10y agoPosted Aug 10, 2016, 5:28 AM use foreach loop on xml data and store in data table . 0
DKDivya Maheswari Kiyanuru10y agoPosted Aug 10, 2016, 4:29 AM Thanks for the reply, I tried this but its bing the first table not the nested tables. 0
Bikesh Srivastava10y agoPosted Aug 10, 2016, 3:44 AM Hi you can use this code to bind xml. protectedvoidPage_Load(objectsender,EventArgse) { if(!this.IsPostBack) { this.BindGrid(); } } privatevoidBindGrid() { using(DataSetds=newDataSet()) { ds.ReadXml(Server.MapPath("~/Customers.xml")); GridView1.DataSource=ds; GridView1.DataBind(); } } protectedvoidOnPageIndexChanging(objectsender,GridViewPageEventArgse) { GridView1.PageIndex=e.NewPageIndex; this.BindGrid(); } 0