namespace QueryXMLByLINQ
{
    public partial class Frm_Main : Form
    {
        public Frm_Main()
        {
            InitializeComponent();
        }

        static string strPath = "Employee.xml";
        static string strID = "";

        //窗體加載時(shí)加載XML文件
        private void Form1_Load(object sender, EventArgs e)
        {
            getXmlInfo();
        }

        //顯示選中XML節(jié)點(diǎn)的詳細(xì)信息
        private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            strID = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();//記錄選擇的職工編號(hào)
            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)//遍歷查詢結(jié)果
            {
                textBox11.Text = element.Element("Name").Value;//顯示職工姓名
                comboBox1.SelectedItem = element.Element("Sex").Value;//顯示職工性別
                textBox12.Text = element.Element("Salary").Value;//顯示職工薪水
            }
        }

        #region 將XML文件內(nèi)容綁定到DataGridView控件
        /// <summary>
        /// 將XML文件內(nèi)容綁定到DataGridView控件
        /// </summary>
        private void getXmlInfo()
        {
            DataSet myds = new DataSet();
            myds.ReadXml(strPath);
            dataGridView1.DataSource = myds.Tables[0];
        }
        #endregion
    }
}