• c#读取xml文件到datagridview中


    using System;
    using System.Collections.Generic;
    using System.ComponentModel;
    using System.Data;
    using System.Drawing;
    using System.Linq;
    using System.Text;
    using System.Windows.Forms;
    using System.IO;
    using System.Xml;
    using System.Xml.Linq;
    
    namespace QueryXMLByLINQ
    {
        public partial class Frm_Main : Form
        {
            public Frm_Main()
            {
                InitializeComponent();
            }
    
            static string strPath = "Employee.xml";
            static string strID = "";
    
            //窗体加载时加载XML文件
            private void Form1_Load(object sender, EventArgs e)
            {
                getXmlInfo();
            }
    
            //显示选中XML节点的详细信息
            private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
            {
                strID = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();//记录选择的职工编号
                XElement xe = XElement.Load(strPath);//加载XML文件
                //使用LINT从XML文件中查询信息
                IEnumerable<XElement> elements = from PInfo in xe.Elements("People")
                                                 where PInfo.Attribute("ID").Value == strID
                                                 select PInfo;
                foreach (XElement element in elements)//遍历查询结果
                {
                    textBox11.Text = element.Element("Name").Value;//显示职工姓名
                    comboBox1.SelectedItem = element.Element("Sex").Value;//显示职工性别
                    textBox12.Text = element.Element("Salary").Value;//显示职工薪水
                }
            }
    
            #region 将XML文件内容绑定到DataGridView控件
            /// <summary>
            /// 将XML文件内容绑定到DataGridView控件
            /// </summary>
            private void getXmlInfo()
            {
                DataSet myds = new DataSet();
                myds.ReadXml(strPath);
                dataGridView1.DataSource = myds.Tables[0];
            }
            #endregion
        }
    }
    
    <?xml version="1.0" encoding="UTF-8"?>
    -<Peoples> -<People ID="001"> <Name>小王</Name> <Sex>男</Sex> <Salary>1500</Salary> </People> -<People ID="002"> <Name>小吕</Name> <Sex>男</Sex> <Salary>1500</Salary> </People> -<People ID="003"> <Name>小梁</Name> <Sex>男</Sex> <Salary>1500</Salary> </People> </Peoples>


  • 相关阅读:
    1
    最大子串
    线段树
    mybatis分页插件
    springmvc下载文件
    获“领跑衫”感言
    finnal 评论 II
    用户使用报告
    事后诸葛亮会议 (尸体解剖)
    final阶段成员贡献分
  • 原文地址:https://www.cnblogs.com/javawebsoa/p/2978318.html
Copyright © 2020-2023  润新知