源码网商城,靠谱的源码在线交易网站 我的订单 购物车 帮助

源码网商城

c#读取xml文件到datagridview实例

  • 时间:2021-05-09 14:22 编辑: 来源: 阅读:
  • 扫一扫,手机访问
摘要:c#读取xml文件到datagridview实例
[u]复制代码[/u] 代码如下:
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     } }
[u]复制代码[/u] 代码如下:
<?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>
  • 全部评论(0)
联系客服
客服电话:
400-000-3129
微信版

扫一扫进微信版
返回顶部