基本信息
源码名称:C#读取xml文件数据。显示在datagridview
源码大小:0.04M
文件格式:.rar
开发语言:C#
更新时间:2020-08-16
   友情提示:(无需注册或充值,赞助后即可获取资源下载链接)

     嘿,亲!知识可是无价之宝呢,但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下,绝对物超所值哦!如有下载和支付问题,请联系我们QQ(微信同号):78630559

本次赞助数额为: 2 元 
   源码介绍

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;

namespace XML_Demp
{
    public partial class frmMin : Form
    {
        public frmMin()
        {
            InitializeComponent();
        }

        XmlDocument xmldoc = new XmlDocument();

        private void LoadXML()
        {
            DataSet ds = new DataSet();
            ds.ReadXml("../../XMLfile.xml");
            DataTable dt = new DataTable();
            if (ds.Tables.Count > 0)
            {
                dt = ds.Tables[0];
                dgvXML.DataSource = dt;
            }
            else
            {
                cbClass.SelectedIndex = 0;
            }
            try
            {
                if (dgvXML.DataSource != null)
                {
                    for (int i = 0; i < dgvXML.RowCount; i  )
                    {
                        cbClass.Items.Remove(dgvXML.Rows[i].Cells[3].Value.ToString());
                    }
                    cbClass.SelectedIndex = 0;
                    txtClass.Text = cbClass.SelectedItem.ToString();
                }
            }
            catch
            {
                cbClass.SelectedIndex = 0;
                txtClass.Text = cbClass.SelectedItem.ToString();
            }
        }

        private void frmMin_Load(object sender, EventArgs e)
        {
            LoadXML();
        }

        private void btAdd_Click(object sender, EventArgs e)
        {
            if (txtSvg.Text != string.Empty)
            {                
                xmldoc.Load("../../xmlfile.xml");
                XmlNode nodes = xmldoc.SelectSingleNode("school");
                XmlElement elment = xmldoc.CreateElement("班级");
                elment.SetAttribute("班级", txtClass.Text);
                XmlElement xmlman = xmldoc.CreateElement("男生");
                xmlman.InnerText = txtMan.Text;
                elment.AppendChild(xmlman);
                XmlElement xmlwoman = xmldoc.CreateElement("女生");
                xmlwoman.InnerText = txtWoman.Text;
                elment.AppendChild(xmlwoman);
                XmlElement xmlsvg = xmldoc.CreateElement("总人数");
                txtSvg.Text = Convert.ToString(int.Parse(txtMan.Text)   int.Parse(txtWoman.Text));
                xmlsvg.InnerText = txtSvg.Text;
                elment.AppendChild(xmlsvg);
                nodes.AppendChild(elment);
                xmldoc.Save("../../xmlfile.xml");
                MessageBox.Show("操作成功!","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
                LoadXML();
            }
        }

        private void txtWoman_Leave(object sender, EventArgs e)
        {
            if (txtMan.Text != string.Empty && txtClass.Text != string.Empty)
            {
                int manNum = int.Parse(txtMan.Text);
                int womanNum = int.Parse(txtWoman.Text);
                txtSvg.Text = Convert.ToString(manNum   womanNum);
            }
        }

        private void cbClass_SelectedIndexChanged(object sender, EventArgs e)
        {
            txtClass.Text = cbClass.SelectedItem.ToString();
        }

        private void btUpdate_Click(object sender, EventArgs e)
        {
            xmldoc.Load("../../xmlfile.xml");
            XmlNodeList list = xmldoc.SelectSingleNode("school").ChildNodes; //获取school下的所有子节点
            //获取要修改的班级
            string strclass = dgvXML.SelectedCells[3].Value.ToString();
            //获取要修改的男生人数
            string manNum = dgvXML.SelectedCells[0].Value.ToString();
            //获取要修改的女生人数
            string womanNum = dgvXML.SelectedCells[1].Value.ToString();
            //计算总人数
            int svg = int.Parse(manNum)   int.Parse(womanNum);
            //开始修改
            foreach (XmlNode xn in list) //遍历所有子节点
            {
                XmlElement xe = (XmlElement)xn; //将xn转换为XmlElmemnt
                //开始进行修改操作,先更改班级信息. 更改"二班"为"*班"
                if (xe.GetAttribute("班级") == strclass) //如果班级属性是二班
                {
                    xe.SetAttribute("班级", txtClass.Text); //则更改

                    XmlNodeList list1 = xe.ChildNodes; //继续向下找子级元素
                    foreach (XmlNode xn1 in list1)
                    {
                        XmlElement xe1 = (XmlElement)xn1; //继续转型
                        if (xe1.Name == "男生") //如果匹配
                        {
                            xe1.InnerText = txtMan.Text;
                            if (xe1.Name == "总人数")
                            {
                                xe1.InnerText = Convert.ToString(int.Parse(txtMan.Text)   int.Parse(womanNum));
                            }
                            break;//找到后即可跳出
                        }
                    }
                    break; //找到后即可跳出
                }                
            }            
            xmldoc.Save("../../xmlfile.xml");
            LoadXML();
        }
    }
}