当前位置: 代码迷 >> VBA >> infopath 数据在代码里插入重复节,该怎么解决
  详细解决方案

infopath 数据在代码里插入重复节,该怎么解决

热度:5256   发布时间:2013-02-26 00:00:00.0
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 + "');";                        }


那么,怎么把数据反过来,在代码里插入重复节?

------解决方案--------------------------------------------------------
顶顶吧...