获取Infopath中数据源的某列的值

有一需求，重复表中有一下拉列表，绑定了一个数据源（部门信息，显示部门名称，值为部门ID），现需要根据下拉列表选中的值获得 部门代码。 部门名称，部门ID，部门代码都是数据源中的列。 在下拉列表的 change event 中添加代码

 

public void Dept_Changed(object sender, XmlEventArgs e)
        {
            // Write your code here to change the main data source.
            XPathNavigator xnDoc = this.MainDataSource.CreateNavigator();
            XPathNavigator xnText = (XPathNavigator)sender;
            XPathNavigator xnName = xnDoc.SelectSingleNode("/my:myFields/my:Dept_Name", this.NamespaceManager);
            XPathNavigator xnCode = xnDoc.SelectSingleNode("/my:myFields/my:Dept_Code", this.NamespaceManager);
            XPathNavigator xnFD = DataSources["Department Information"].CreateNavigator();
            XPathNavigator items = xnFD.SelectSingleNode("/dfs:myFields/dfs:dataFields/dfs:Department_Information[@ID=" + xnText.Value + "]", NamespaceManager);

            xnName.SetValue(items.GetAttribute("Department_Name", ""));
            xnCode.SetValue(items.GetAttribute("Department_Code", ""));
        }