[ C# ] XML Parsing

■ DataSet To XML

    http://mollelo.tistory.com/19

  

■ XmlDocument

    http://mainia.tistory.com/2720

    http://goodhelper.egloos.com/1916101

   http://blog.naver.com/kmc7468/220660088517

    http://cafe.naver.com/codein/727

private DataSet XML_Parsing_DataSet(string sXML)
{
    StringBuilder XML_Parsing = new StringBuilder();
    System.Xml.XmlNodeList xnList;
 
    DataSet ds = new DataSet();
 
    /// ===============
    /// Use XmlDocument
    /// ===============
    try
    {
        XML_Parsing = new StringBuilder();
 
        System.Xml.XmlDocument xml = new System.Xml.XmlDocument();
 
        //xml.Load(url);
        xml.LoadXml(sXML);
    
        /// DataSet Add!!
        ds.Tables.Add("tblRETURNFLAG");
        ds.Tables.Add("tblROWDATA");
 
        // RETURNFLAG
        ds.Tables["tblRETURNFLAG"].Columns.Add("RETURNFLAG");
        DataRow dr1 = ds.Tables["tblRETURNFLAG"].NewRow();
        dr1["RETURNFLAG"] = xml.SelectNodes("/ROOT/RETURNFLAG")[0].InnerText;
        ds.Tables["tblRETURNFLAG"].Rows.Add(dr1);
 
        // ROWDATA
        xnList = xml.SelectNodes("/ROOT/ROWDATA"); //접근할 노드
        if (xnList.Count > 0)
        {
            for (int i = 0; i < xnList[0].ChildNodes.Count; i++)
            {
                ds.Tables["tblROWDATA"].Columns.Add(xnList[0].ChildNodes[i].Name);
            }
 
            foreach (System.Xml.XmlNode xn in xnList)
            {
                DataRow dr2 = ds.Tables["tblROWDATA"].NewRow();
 
                for (int i = 0; i < xn.ChildNodes.Count; i++)
                {
                    dr2[xn.ChildNodes[i].Name] = xn.ChildNodes[i].InnerText;
                }
 
                ds.Tables["tblROWDATA"].Rows.Add(dr2);
            }
        }
 
        if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
        {
            XML_Parsing.Append("<ROOT>" + "\r\n\r\n");
            XML_Parsing.Append(" <RETURNFLAG>" + ds.Tables[0].Rows[0]["RETURNFLAG"].ToString() + "</RETURNFLAG>" + "\r\n\r\n");
 
            if (ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0)
            {
                for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
                {
                    XML_Parsing.Append(" <ROWDATA" + (i + 1).ToString() + ">" + "\r\n");
 
                    for (int j = 0; j < ds.Tables[1].Columns.Count; j++)
                    {
                        XML_Parsing.Append("    <ROWDATA>" + (j + 1).ToString() + ". " + ds.Tables[1].Columns[j].ColumnName + " : " + ds.Tables[1].Rows[i][j].ToString() + "\r\n");
                    }
 
                    XML_Parsing.Append(" </ROWDATA" + (i + 1).ToString() + ">" + "\r\n\r\n");
                }
            }
 
            XML_Parsing.Append("</ROOT>");
        }
 
        meMonitoring.Text = XML_Parsing.ToString();
 
        return ds;
    }
    catch (ArgumentException ex)
    {
        MessageBox.Show("XML 문제 발생\r\n" + ex);
        return null;
    }
}