將表格中的資料轉換成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());
                              
            }