• 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>


  • 相关阅读:
    ubuntu上如何安装和卸载google chrome 浏览器
    另眼相看“那些争议最大的编程观点”
    读完了csapp(中文名:深入理解计算机系统)
    SSL工作原理
    linux signal 处理
    PCB设计资料:看到最后才知道是福利
    String.Format使用方法
    matlab三维画图
    spin_lock &amp; mutex_lock的差别?
    Hibernate Criterion
  • 原文地址:https://www.cnblogs.com/javawebsoa/p/2978318.html
Copyright © 2020-2023  润新知