Xml转化为DataTable

 /// 

        /// XML转换为DataTable
        /// 
        /// 文件路径
        /// 节点路径
        /// 返回DataTable
        public static DataTable XmlToDataTable(string fileName, string tagName)
        {
            XmlDocument Xmldoc = new XmlDocument();
            Xmldoc.Load(fileName);
            XmlNodeList xlist = Xmldoc.SelectNodes(tagName);
            DataTable dt = new DataTable();
            DataRow dr;
            for (int i = 0; i < xlist.Count; i++)
            {
                dr = dt.NewRow();
                XmlElement xe = (XmlElement)xlist.Item(i);
                for (int j = 0; j < xe.Attributes.Count; j++)
                {
                    if (!dt.Columns.Contains("@" + xe.Attributes[j].Name))
                    {
                        dt.Columns.Add("@" + xe.Attributes[j].Name);
                    }
                    dr["@" + xe.Attributes[j].Name] = xe.Attributes[j].Value;
                }
                for (int j = 0; j < xe.ChildNodes.Count; j++)
                {
                    if (!dt.Columns.Contains(xe.ChildNodes.Item(j).Name))
                    {
                        dt.Columns.Add(xe.ChildNodes.Item(j).Name);
                    }
                    dr[xe.ChildNodes.Item(j).Name] = xe.ChildNodes.Item(j).InnerText;
                }
                dt.Rows.Add(dr);
            }
            return dt;
        }