如何将 XML 读入 DataTable? [英] How to read XML into a DataTable?

问题描述

我在内存中的 string 中有一些 XML，就像这样:

I have some XML in a string in memory exactly like this:

<symbols>
  <symbol>EURCHF</symbol>
  <symbol>EURGBP</symbol>
  <symbol>EURJPY</symbol>
  <symbol>EURUSD</symbol>
</symbols>

我想将其读入 DataTable.我是这样做的:

I want to read this into a DataTable. I am doing it like this:

DataTable dt = new DataTable();
dt.TableName = "symbols";
dt.Columns.Add("symbol");

if (!String.IsNullOrEmpty(symbols))
{
    dt.ReadXml(new StringReader(symbols));
}

然而，当我检查行数时，DataTable 最终有零行.我做错了什么?

However when I check the number of rows, the DataTable ends up having zero rows. What am I doing wrong?

推荐答案

从这里:http://www.dreamincode.net/code/snippet3186.htm

// <summary>
/// method for reading an XML file into a DataTable
/// </summary>
/// <param name="file">name (and path) of the XML file</param>
/// <returns></returns>
public DataTable ReadXML(string file)
{
    //create the DataTable that will hold the data
    DataTable table = new DataTable("XmlData");
    try
    {
        //open the file using a Stream
        using(Stream stream = new  FileStream(file, FileMode.Open, FileAccess.Read))
        {
            //create the table with the appropriate column names
            table.Columns.Add("Name", typeof(string));
            table.Columns.Add("Power", typeof(int));
            table.Columns.Add("Location", typeof(string));

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

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

您可能想看看 DataTable.ReadXml 方法.

You might want to take a look at DataTable.ReadXml method.

如果内存中有 xml 对象，则可以直接使用 ReadXml 方法.DataTable.ReadXml(MemoryStream Object);

If you have xml object in memory you can use the ReadXml method directly. DataTable.ReadXml(MemoryStream Object);

编辑 2:我做了导出.需要以下 XML 架构:

EDIT 2: I did the export. The following XML Schema is required:

<?xml version="1.0" standalone="yes"?>
<DocumentElement>
  <symbols>
    <symbol>EURCHF</symbol>
  </symbols>
  <symbols>
    <symbol>EURGBP</symbol>
  </symbols>
  <symbols>
    <symbol>EURJPY</symbol>
  </symbols>
</DocumentElement>

这篇关于如何将 XML 读入 DataTable?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！