XML

XML的读取

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Xml.Linq;

namespace XMLRead
{
    class Program
    {
        static void Main(string[] args)
        {
            string path = @"D:RuPengRupengXMLReadMyFirstXml.xml";
            XDocument xdoc = XDocument.Load(path);
            //根节点
            XElement root = xdoc.Root;
            //子节点
            //根节点下的所有的子节点
            foreach (XElement item in root.Elements())
            {
                Console.WriteLine(item.Name+"=="+item.Attribute("StuId").Value);
                foreach (XElement xele in item.Elements())
                {
                    Console.WriteLine(xele.Name + "==" + xele.Value);
                }
            }

            Console.ReadKey();
        }
    }
}

XML文件的写入：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Xml.Linq;

namespace XmlWrite
{
    class Program
    {
        static void Main(string[] args)
        {
           // xml的写入
            XDocument xdoc = new XDocument();
            //根节点
            XElement root = new XElement("Person");
            XElement student = new XElement("Student");
            student.SetAttributeValue("StuId","12");
            student.SetElementValue("name","佐助");
            student.SetElementValue("gender", "男");
            student.SetElementValue("age","15");
            root.Add(student);//student写入到Root
            xdoc.Add(root);//把根节点写入到文件中
            //保存
            xdoc.Save("1.xml");
        }
    }
}

将XML文件中的数据读取并写入数据库

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Xml.Linq;

namespace OutPutFromSql
{
    class Program
    {
        static void Main(string[] args)
        {
            //读取xml中的数据写入数据库
            XDocument xdoc = XDocument.Load("student.xml");
            //根节点
            XElement root = xdoc.Root;
            foreach(XElement item in root.Elements())
            {
                //Console.WriteLine(item.Element("Name").Value);
                //Console.WriteLine(item.Element("Age").Value);
                //Console.WriteLine(item.Element("Gender").Value);
                string sql = "insert into  student(Sname,Sage,Ssex) values(@Name,@Age,@Gender)";
                SqlParameter[] ps ={
                               new SqlParameter{ParameterName="@Name",Value= item.Element("Name").Value},
                              new SqlParameter{ParameterName="@Age",Value=Convert.ToInt32(item.Element("Age").Value)},
                               new SqlParameter{ParameterName="@Gender",Value=item.Element("Gender").Value}                                     
                                 };
                SqlHelper.ExecuteNonQuery(sql,ps);
            }

            Console.WriteLine("结束");
            Console.ReadKey();


        }

        private static void ReaderData()
        {
            List<Student> list = new List<Student>();
            //读取数据
            DataTable dt = SqlHelper.GetDataTable("select * from student");
            if (dt.Rows.Count > 0)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    Student stu = RowToStudent(dr);
                    list.Add(stu);
                }
            }
            //遍历集合中的数据
            XDocument xdoc = new XDocument();
            XElement root = new XElement("Person");
            for (int i = 0; i < list.Count; i++)
            {
                Student stu = list[i];
                XElement student = new XElement("Student");
                student.SetAttributeValue("Id", stu.Id.ToString());
                student.SetElementValue("Name", stu.Sname);
                student.SetElementValue("Age", stu.Sage.ToString());
                student.SetElementValue("Gender", stu.Ssex);
                root.Add(student);
            }
            xdoc.Add(root);
            xdoc.Save("student.Xml");
            //Console.ReadKey();
        }

        private static Student RowToStudent(DataRow dr)
        {
            Student stu = new Student();
            stu.Sage = Convert.ToInt32(dr["Sage"]);
            stu.Ssex = dr["Ssex"].ToString();
            stu.Id = Convert.ToInt32(dr["Id"]);
            stu.Sname = dr["Sname"].ToString();
            return stu;
        }
    }
}