将表格中的数据转换成XmlDocument

 

//在NET中处理XML数据是很方便的，但是对于初学者来说，可能有时候还是有些困难，
//以下代码是将表转换成XmlDocument,然后在读取出来的示例，很简单，可以自己在进行扩充. 
  private XmlDocument CreateXmlDocument()
        ...{
            XmlDocument xmldoc = new XmlDocument();
            XmlNode xnod;
            XmlElement xenl;

            //描述信息
            xnod = xmldoc.CreateNode(XmlNodeType.XmlDeclaration, "", "");
               xnod.InnerText += " encoding="UTF-8"";
            xmldoc.AppendChild(xnod);

            //根元素
            xenl = xmldoc.CreateElement("", "body", "");
            xmldoc.AppendChild(xenl);

            XmlNode nod = xmldoc.SelectSingleNode("body");

            //设置元素的值
            XmlElement element;
             element = xmldoc.CreateElement("item");                    
              element.SetAttribute("Name","Manqing Yu");                                      
               element.SetAttribute("Age","24");                                     
               element.SetAttribute("Sex", "男");            
               nod.AppendChild(element);
                
            }
            xmldoc.Save("c:XmlTest.xml");
            return xmldoc;
        }

//读取XML数据 
            XmlNodeList nodeList = xmldoc.SelectNodes("body/item");
            StringBuilder strBody;
                  
            for (int row = 0; row < nodeList.Count; row++)
            ...{                
              
                MessageBox.Show(nodeList[row].Attributes["Name"].Value.ToString());
                MessageBox.Show(nodeList[row].Attributes["Age"].Value.ToString());
                MessageBox.Show(nodeList[row].Attributes["Sex"].Value.ToString());
                              
            }