infopath 数据在代码里插入重复节
现在用这个方法,把重复节的内容插入sql
- C# code
XPathNavigator domNav = MainDataSource.CreateNavigator(); XPathNodeIterator rows = domNav.Select("/my:myFields/my:qj_detail", NamespaceManager); string inQjDetailSql = string.Empty; //保存请假详细信息 while (rows.MoveNext()) { string beginDate = rows.Current.SelectSingleNode("my:beginDate", NamespaceManager).Value.ToString(); string endDate = rows.Current.SelectSingleNode("my:endDate", NamespaceManager).Value.ToString(); string reson = rows.Current.SelectSingleNode("my:reson", NamespaceManager).Value.ToString(); string note = rows.Current.SelectSingleNode("my:note", NamespaceManager).Value.ToString(); inQjDetailSql += "INSERT INTO qingjia_detail (qj_id,Begin_Date,End_Date,Style,Note)"; inQjDetailSql += " VALUES ('" + qj_id + "','" + beginDate + "','" + endDate + "','" + reson + "','" + note + "');"; }
那么,怎么把数据反过来,在代码里插入重复节?
[解决办法]
创建一个xml数据源,用重复数据填充这个xml数据源。然后用重复控件list boxes, drop-down list boxes, combo boxes, repeating sections, 或repeating tables与这个xml数据源绑定:
[解决办法]
XPathNavigator domNav = this.MainDataSource.CreateNavigator();
for (int i = 0; i < filelist.Length - 2; i++)
{
XPathNavigator FileList = domNav.SelectSingleNode("/my:Task0/my:group1", NamespaceManager);
XPathNavigator FileNode = domNav.SelectSingleNode("/my:Task0/my:group1/my:group2", NamespaceManager);
FileList.AppendChild(FileNode);
}