how to convert xml to DataTable in C#

Question

My customer gave me a webservice which was written in ColdFusion and I have been trying to consume it with C#. I have been trying to convert XML to DataTable but I am getting a DataTable with no rows.

Here is my XML:

<?xml version='1.0' standalone='yes'?>
<dtFirms>
  <NR>2</NR>
  <NAME>CS Net - 2014</NAME>
  <NRTIT>2 - 2014 - CS Net - 2014</NRTIT>
  <PERIOD>7</PERIOD>
</dtFirms>

and this is my C# code. It always return empty DataTable. What am I doing wrong?

    public DataTable ReadXmlIntoDataTable(string s) {

    //create the DataTable that will hold the data
    DataTable table = new DataTable("dtFirms");
    try
    {
        //open the file using a Stream
        using (Stream stream = GenerateStreamFromString(s))
        {
            //create the table with the appropriate column names
            table.Columns.Add("NR", typeof(string));
            table.Columns.Add("NAME", typeof(string));
            table.Columns.Add("NRTIT", typeof(string));
            table.Columns.Add("PERIOD", typeof(int));

            //use ReadXml to read the XML stream
            table.ReadXml(stream);

            //return the results
            return table;
        }
    }
    catch (Exception ex)
    {
        return table;
    }
}


public Stream GenerateStreamFromString(string s)
{
    MemoryStream stream = new MemoryStream();
    StreamWriter writer = new StreamWriter(stream);
    writer.Write(s);
    writer.Flush();
    stream.Position = 0;
    return stream;
}

It always return empty DataTable. What am I doing wrong? Please help me.

You have to read each of the values in the properties and convert them to the required value manually (except for string). — MrFox, Apr 01 '14 at 12:49
possible duplicate of [How to read XML into a DataTable?](http://stackoverflow.com/questions/4461123/how-to-read-xml-into-a-datatable) — Mahmoud Darwish, Apr 01 '14 at 12:55
http://msdn.microsoft.com/en-us/library/vstudio/fx29c3yd(v=vs.100).aspx — Dzmitry Martavoi, Apr 01 '14 at 12:56
since you can't change the schema, try http://stackoverflow.com/questions/6228315/convert-xml-to-datatable — Mahmoud Darwish, Apr 01 '14 at 12:57

score 0 · Accepted Answer · answered Apr 01 '14 at 13:01

0

You can create schema for your xml file.
By using XSD.exe you can generate class structure for schema. Use these xml schema classes for iterating through the xml file.
Use table.Rows.Add() function to add entries in data table.

answered Apr 01 '14 at 13:01

AkshayP

188
3
11

how to convert xml to DataTable in C#

1 Answers1

Linked