?using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using System.Xml;

/// <summary>
/// XML_Catories 的摘要說明
///完成 　Catories的數據寫出
///類別
/// </summary>
public class XML_Catories
{
	public XML_Catories()
	{
		//
		// TODO: 在此處添加構造函數邏輯
		//
	}
     /// <summary>
    /// 把數據寫到xml文件中
    /// </summary>
    /// <param name="FileName">要打開的XML文件</param>
    /// <param name="name">類別名稱</param>
    /// <param name="ID">類別編號</param>
   
    public void WriteXml(string FileName, string ID, string name)
    {
        //初始化XML文檔操作類
        XmlDocument myXml = new XmlDocument();

        //加載指定的XML文件
        myXml.Load(FileName);
        /*****************
         *  創建根
        myXml.LoadXml()
        myXml.LoadXml("<?xml version='1.0' ?>" +
               "<book genre='novel' ISBN='1-861001-57-5'>" +
               "<title>Pride And Prejudice</title>" +
               "</book>");
       ************************/
        /***********************/
        /*清空以前的xmL的方法
         * 
         * **************************/
        XmlNode roots = myXml.DocumentElement;

        while (roots.ChildNodes.Count > 0)
        {
            roots.RemoveChild(roots.FirstChild);
        }
        myXml.Save(FileName);


        //添加元素-類別編號
        XmlElement ele0 = myXml.CreateElement("category_id");
        XmlText Text0 = myXml.CreateTextNode(ID);

        //添加元素-類別名稱
        XmlElement ele1 = myXml.CreateElement("name");
        XmlText Text1 = myXml.CreateTextNode(name);

     　
        //添加元素的節點---CatoriesWrite
        XmlNode newElem = myXml.CreateNode("element", "CatoriesWrite", "");

        //在節點中添加元素
        newElem.AppendChild(ele0);
        newElem.LastChild.AppendChild(Text0);
        newElem.AppendChild(ele1);
        newElem.LastChild.AppendChild(Text1);
      

        //將節點添加到文檔中
        XmlElement root = myXml.DocumentElement;
        root.AppendChild(newElem);

        //保存所有的修改
        
        myXml.Save(FileName);

    }

    public DataTable ReaderXml(string FileName)
    {
       

        XmlDocument doc = new XmlDocument();
        doc.Load(FileName);
        XmlNodeList nodes = doc.SelectNodes(@"//CatoriesWrite");
        //創建一張表
        DataTable dt = new DataTable();
        //添加列-類別編號
        dt.Columns.Add("category_id", typeof(String));
        //添加列-類別名稱
        dt.Columns.Add("Name", typeof(String));
       







        foreach (XmlNode node in nodes)
        {
            DataRow row = dt.NewRow();
            row["category_id"] = node.ChildNodes[0].ChildNodes[0].InnerText;
            row["Name"] = node.ChildNodes[1].ChildNodes[0].InnerText;
           
            dt.Rows.Add(row);
        }


        //返回datatable 
        return dt;

    }
   
}