C# XML匯入資料庫

標籤：

using MySql.Data.MySqlClient;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)        {           //Xml匯入資料庫            //讀取XML           XDocument xdoc = XDocument.Load(@"C:\Users\Administrator\Desktop\xml\stu.xml");            //根節點            XElement root = xdoc.Root;            //遍曆根節點下所有的子節點            foreach (var item in root.Elements())            {                string sql = "INSERT INTO t_student(name,age,gender) VALUES(@name,@age,@gender);";                MySqlParameter[] ps = {                                          new MySqlParameter("@name",item.Element("StuName").Value),                                          new MySqlParameter("@age",item.Element("StuAge").Value),                                          new MySqlParameter("@gender",item.Element("StuGender").Value)                                      };                MySqlHelper.ExecuteNonQuery(sql,ps);            }            Console.WriteLine("資料匯入成功!");            Console.ReadKey();        }              }}

 

C# XML匯入資料庫