how to load nested XML into data table in c#

Question

i want to convert XML data into data table.my XML file contains many nested tags.how can i display those data in a data table using C#

<school>
   <staff>
      <staffname>raj</staffname>
      <staffname>rani</staffname>
   </staff>
   <students>
      <firstclass>
        <name>nani</name>
        <rollno>1</rollno>
      </firstclass>
      <secondclass>
        <name>rani</name>
        <rollno>1</rollno>
      </secondclass>
</students>
</school>

this is the sample file .Now i want to display this data in a Data Table using c#.

can any one help me to solve this issue

Have you tried anything? And possible ideas how you might want to do this? — amuz
– amuz, Commented Jul 19, 2016 at 13:19
@amuz i have tried with a single tag and i got the result like <details> <name>akhil<//name> </details> i used the same format — naveenkumar
– naveenkumar, Commented Jul 19, 2016 at 13:26
@abhi i have nearly 1000 xml tags so,its difficult to write for all the tags — naveenkumar
– naveenkumar, Commented Jul 19, 2016 at 13:29
@naveenkumar chk my solution below it will help you out, keep the xml in txt file and give filename in filepath — abhi
– abhi, Commented Jul 19, 2016 at 13:31

abhi · Accepted Answer · 2016-07-19 13:22:19Z

2

You can use the following code

 DataSet dsTest = new DataSet();
 dsTest.ReadXml(filepath, XmlReadMode.Auto);
 DataTable dt = dsTest.Tables[0];

answered Jul 19, 2016 at 13:22

abhi

1,08410 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

how to load nested XML into data table in c#

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