Read XML file with multiple nodes and display in datagridview

15y12.4kLearn iOS Programming

Hello,

I have an XML file with the following layout:


        Test
        0

            service
            service



I use this code to read the XML file:

  string filePath = "C:\\Users\\test\\Desktop\\test.xml";

            //XmlTextReader r = new XmlTextReader(filePath);

            dsXML.ReadXml(filePath, XmlReadMode.Auto);
            dgvXML.AutoGenerateColumns = true;
            dgvXML.DataSource = dsXML;
            dgvXML.DataMember = "name";

However, I only get the following columns in the datagridview:

item1
item2

but I would like to see:

item1
item2
info1
info2

What am I doing wrong?

Thanks in advance.

3 Replies

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

Suthish Nair15y ago
You need some extra coding here.

Dynamically creation of DataTable will help you to create the DataSource.

As per given example you need four columns.

For that you need seprate logic to retrive xml nodes and create DataTable.

refer blog: Different ways of reading an XML file
JR15y ago
Thanks for the link. However, I don't think it is really useful to me. This datamember is the main problem I think. When I choose "info" as datamember only info1 and info2 are displayed in the datagridview.

Is this because the "info" is read into another table? if yes, is there a way to add it the content to the other rows (by adding columns)?

Thanks in advance for all the advice!

Cheers.
Liutauras Medziunas15y ago
I think that this url http://csharptutorial.blogspot.com/2006/10/reading-xml-fast.html could help you.