C# 資料庫資料匯出XML

標籤：

using System;using System.Collections.Generic;using System.Data;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Xml.Linq;namespace XML{    class Program    {        static void Main(string[] args)        {            //建立一個泛型集合            List<students> list = new List<students>();            //讀取資料            DataTable tb = MySqlHelper.ExecuteQuery("select * from t_student");            if (tb.Rows.Count > 0)            {                //有資料                foreach (DataRow r in tb.Rows)                {                    students stu = RowToStudent(r);                    if (stu != null)                    {                        list.Add(stu);                    }                }            }                                   XDocument xdoc = new XDocument();            //XML根節點            XElement root = new XElement("Person");            //遍曆集合            for (int i = 0; i < list.Count; i++)            {                students stu = list[i];                XElement student = new XElement("Student");                student.SetAttributeValue("StuId",stu.ID.ToString());                student.SetElementValue("StuName", stu.Name);                student.SetElementValue("StuAge", stu.Age);                student.SetElementValue("StuGender", stu.Gender);                root.Add(student);            }            xdoc.Add(root);            //儲存            xdoc.Save(@"C:\Users\Administrator\Desktop\xml\stu.xml");            Console.WriteLine("資料全部匯出!");            Console.ReadKey();        }       public static students RowToStudent(DataRow dr)        {             //為students對象欄位賦值            students stu = new students();            stu.ID = Convert.ToInt32( dr["id"]);            stu.Name = dr["name"].ToString();            stu.Age = Convert.ToInt32(dr["age"]);            stu.Gender = dr["gender"].ToString();            return stu;                    }    }}

 

C# 資料庫資料匯出XML