XML读取操作

来源：互联网发布：手机做热点软件编辑：程序博客网时间：2024/05/21 08:54

Test.xml文件：

<?xml version="1.0" encoding="utf-8" ?>
<Students>
<Student>
    <ID>1</ID>
    <Name>小谭</Name>
    <Age>20</Age>
</Student>
<Student>
    <ID>2</ID>
    <Name>小宁</Name>
    <Age>21</Age>
</Student>
<Student>
    <ID>3</ID>
    <Name>小江</Name>
    <Age>21</Age>
</Student>
<Student>
    <ID>4</ID>
    <Name>小高</Name>
    <Age>20</Age>
</Student>
<Student>
    <ID>5</ID>
    <Name>小艳</Name>
    <Age>20</Age>
</Student>
<Student>
    <ID>6</ID>
    <Name>小琼</Name>
    <Age>20</Age>
</Student>
</Students>

操作后台：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Xml;

namespace MyWeb
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {

            }
        }

protected void btn_Click(object sender, EventArgs e)
{

            this.gvTest.DataSource = GetDataByTable();
            this.gvTest.DataBind();
        }

        private DataTable GetDataByTable()
        {
            string filename = Server.MapPath("~/Test.xml");
            XmlDocument doc = new XmlDocument();
            doc.Load(filename);
            XmlNodeList nodelist = doc.SelectNodes("/Students/Student");
            DataTable dt = new DataTable();
            dt.Columns.Add("ID", typeof(int));
            dt.Columns.Add("Name", typeof(string));
            dt.Columns.Add("Age", typeof(int));
            try
            {
                foreach (XmlNode node in nodelist)
                {
                    DataRow dr = dt.NewRow();
                    dr["ID"] = int.Parse(node.ChildNodes[0].InnerText.ToString());
                    dr["Name"] = node.ChildNodes[1].InnerText.ToString();
                    dr["Age"] = int.Parse(node.ChildNodes[2].InnerText.ToString());
                    dt.Rows.Add(dr);
                }
                return dt;
            }
            catch (Exception)
            {
                return null;
            }
        }

        private List<Student> GetDataByNodeListXML()
        {
            string filename = Server.MapPath("~/Test.xml");
            XmlDocument doc = new XmlDocument();
            doc.Load(filename);
            XmlNodeList nodelist = doc.SelectNodes("/Students/Student");
            List<Student> list = new List<Student>();
            foreach (XmlNode node in nodelist)
            {
                Student stu = new Student();
                stu.ID = int.Parse(node.ChildNodes[0].InnerText.ToString());
                stu.Name = node.ChildNodes[1].InnerText.ToString();
                stu.Age = int.Parse(node.ChildNodes[2].InnerText.ToString());
                list.Add(stu);
            }
            return list;
        }

        private DataSet GetDataByXML()
        {
            DataSet ds = new DataSet();
            string filename = Server.MapPath("~/Test.xml");
            ds.ReadXml(filename);
            return ds;
        }

        private IQueryable<userinfo> GetDataByLinq()
        {
            MyTestDataContext context = new MyTestDataContext();
            var users = from c in context.userinfo select c;
            return users;
        }
    }

    public class Student
    {
        public int ID { get; set; }
        public string Name { get; set; }
        public int Age { get; set; }
    }
}