c#递归生成XML实例

本文实例讲述了c#递归生成XML的方法。分享给大家供大家参考。具体实现方法如下:

这里结合网上搜到的资料,写了个递归生成xml,经过调试可以使用,数据库结构如下图所示:

代码如下:

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using System.Xml;

//using System.Data;

using System.Data.SqlClient;

namespace WindowsApplication1 {     public partial class frmReadXML : Form     {         public frmReadXML()         {             InitializeComponent();         }         public string connstr = System.Configuration.ConfigurationManager.AppSettings["connstr"].ToString();                private void frmReadXML_Load(object sender, EventArgs e)         {             SqlConnection conn = new SqlConnection(connstr);             conn.Open();             SqlCommand comm = new SqlCommand();             comm.CommandText = "select * from Nationals";             comm.Connection = conn;             comm.CommandType = CommandType.Text;             SqlDataAdapter sda = new SqlDataAdapter();             sda.SelectCommand = comm;             DataSet ds = new DataSet();             sda.Fill(ds);

            XmlDocument doc = new XmlDocument();             doc.AppendChild(doc.CreateXmlDeclaration("1.0","",""));             XmlElement rootnode = doc.CreateElement("root");             doc.AppendChild(rootnode);

            CreateXMLtree(ds,doc,"",(XmlElement)null);

        }         DataRow[] dr;                 public void CreateXMLtree(DataSet ds, XmlDocument doc, string parentCode,XmlElement parentNode)         {

            if (parentCode == "")             {                  dr = ds.Tables[0].Select("parentCode=''");             }             else             {                 dr = ds.Tables[0].Select("parentCode='" + Convert.ToString(parentCode) + "'");             }             XmlElement tempNode;             foreach (DataRow drv in dr)             {                 if (parentCode == "")                 {                     tempNode = doc.CreateElement("c"+drv["Code"].ToString()); //创建一级节点                     tempNode.SetAttribute("name", drv["name"].ToString()); //创建属性                     //tempNode.InnerText = drv["name"].ToString();                     doc.DocumentElement.AppendChild(tempNode);//添加一级节点                     CreateXMLtree(ds,doc,drv["Code"].ToString(),tempNode);                 }                 else                 {                     tempNode = doc.CreateElement("c"+drv["Code"].ToString().Replace(".", ""));                     tempNode.SetAttribute("name", drv["name"].ToString());                     //tempNode.InnerText = drv["name"].ToString();                     parentNode.AppendChild(tempNode);                     CreateXMLtree(ds, doc, drv["Code"].ToString(), tempNode);                 }             }             doc.Save(AppDomain.CurrentDomain.BaseDirectory+"/xxx.xml");                     }     } }

希望本文所述对大家的C#程序设计有所帮助。