基本信息
源码名称:C#读取xml文件数据。显示在datagridview
源码大小:0.04M
文件格式:.rar
开发语言:C#
更新时间:2020-08-16
友情提示:(无需注册或充值,赞助后即可获取资源下载链接)
嘿,亲!知识可是无价之宝呢,但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下,绝对物超所值哦!如有下载和支付问题,请联系我们QQ(微信同号):78630559
本次赞助数额为: 2 元×
微信扫码支付:2 元
×
请留下您的邮箱,我们将在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();
}
}
}