将Delphi的TClientDataSet生成的XML文件转成.Net的DataSet可以识别的格式

最新推荐文章于 2020-08-01 00:06:59 发布

原创最新推荐文章于 2020-08-01 00:06:59 发布 · 1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#dataset #delphi #.net #xml #string #schema

本文介绍了如何将由Delphi的TClientDataSet生成的XML文件转换为.Net的DataSet可以识别的格式。通过提供的C#代码示例，展示了读取Delphi XML字符串并构造符合.Net要求的DataSet的转换过程。

费话就不说了,转换方法如下,注意这个方法转换的时候没有生成schema,如果要生成schema稍有点麻烦呢

private string ReadDelphiDataSetToNetDataSet(string vDelphiStr, string vTableName)
        {
            string vResult = vDelphiStr;
            XmlTextReader reader = new XmlTextReader(vDelphiStr, XmlNodeType.Document, null);
            reader.Read();
            MemoryStream stream = new MemoryStream();

            XmlTextWriter vXmlTextWriter = new XmlTextWriter(stream, new UTF8Encoding());
            vXmlTextWriter.Formatting = Formatting.Indented;
            vXmlTextWriter.WriteStartDocument();
            vXmlTextWriter.WriteStartElement("NewDataSet");

            while (!reader.EOF)
            {
                if ((reader.NodeType == XmlNodeType.Element && reader.Name.ToUpper() == "ROW"))
                {
                    vXmlTextWriter.WriteStartElement(vTableName);
                    if (reader.HasAttributes)
                    {
                        if (reader.MoveToFirstAttribute())
                        {
                            vXmlTextWriter.WriteElementString(reader.Name, reader.Value);
                            while (reader.MoveToNextAttribute())
                            {
                                vXmlTextWriter.WriteElementString(reader.Name, reader.Value);
                            }
                        }
                        //reader.ReadEndElement();
                    }
                    vXmlTextWriter.WriteEndElement();
                }
                reader.Read();
            }

            vXmlTextWriter.WriteEndElement();
            vXmlTextWriter.WriteEndDocument();
            vXmlTextWriter.Flush();
            vXmlTextWriter.Close();
            reader.Close();
            vResult = Encoding.UTF8.GetString(stream.ToArray());
            stream.Close();
            return vResult;
        }