xml to datatable

xml:

<DocumentElement>
  <cityconfig>
    <city>阿坝州</city>
    <jc>abazhou</jc>
    <nbf>s</nbf>
    <viewname>view_news_title_index_abazhou</viewname>
  </cityconfig>
  <cityconfig>
    <city>阿克苏</city>
    <jc>akesu</jc>
    <nbf>s</nbf>
    <viewname>view_news_title_index_akesu</viewname>
  </cityconfig>
  <cityconfig>
    <city>安达</city>
    <jc>anda</jc>
    <nbf>n</nbf>
    <viewname>view_news_title_index_anda</viewname>
  </cityconfig>
</DocumentElement>

            string path = "./XMLFile1.xml"; ;
            string content = GetContent(path);
            StringReader txtReader = new StringReader(content);
            XmlTextReader xmlReader = new XmlTextReader(txtReader);
            DataSet ds = new DataSet();
            ds.ReadXml(xmlReader);
            string m = "";
            foreach (DataColumn c  in ds.Tables[0].Columns)
            {
                m += c.ColumnName + "-";

            }
            return;// ds.Tables[0];

调用方法：

        public static String GetContent(String vFileName)
        {
            StreamReader reader = new StreamReader(vFileName);
            StringBuilder result = new StringBuilder();
            string line = reader.ReadLine();
            while (line != null)
            {
                result.AppendLine(line);
                line = reader.ReadLine();
            }
            reader.Close();
            return result.ToString();
        }

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!