博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

XML==>Table

Posted on 2010-11-05 00:13  moss_tan_jun  阅读(572)  评论(0编辑  收藏  举报

 

 public DataTable XLM_test(string path, string nodeName)
        {
            DataTable table = new DataTable();
            table.Columns.Add("EmployeeID", typeof(string));
            table.Columns.Add("EName", typeof(string));
            table.Columns.Add("ESex", typeof(string));
            table.Columns.Add("EAge", typeof(string));
            table.Columns.Add("EPlace", typeof(string));
            table.Columns.Add("EMoney", typeof(string));

            XmlDocument doc = new XmlDocument();
            doc.Load(path);
            //XmlNodeList xnl = doc.SelectSingleNode(nodeName).ChildNodes; ;//获取NewDataSet节点的所有子节点
            XmlNodeList xnl = doc.SelectSingleNode("NewDataSet").ChildNodes; ;//获取NewDataSet节点的所有子节点
            foreach (XmlNode xn in xnl)//遍历所有子节点
            {
                XmlElement xe = (XmlElement)xn;//将子节点类型转换为XmlElement类型
                if (xe.Name == "Table")//判断节点名为Table
                {
                    XmlNodeList xnlChild = xe.ChildNodes;//继续获取xe子节点的所有子节点
                    DataRow row = table.NewRow();
                    foreach (XmlNode xnChild in xnlChild)//遍历
                    {
                       
                        XmlElement xeChild = (XmlElement)xnChild;//转换类型
                        //if (xeChild.Name == "EName")
                        //{
                        //    row["EName"] = xeChild.InnerText;
                        //}

                        row[xeChild.Name] = xeChild.InnerText;

                       
                    }
                    table.Rows.Add(row);
                }
            }

            return table;
        }

 

 

 

=================

 webBrowser1.Navigate()