Any help would be appreciated
So here is the error:
System.NullReferenceException
Object reference not set to an instance of an object.
at repeating_table_to_list.FormCode.CTRL70_5_Clicked(Object sender, ClickedEventArgs e)
at Microsoft.Office.InfoPath.Internal.ButtonEventHost.OnButtonClick(DocActionEvent pEvent)
at Microsoft.Office.Interop.InfoPath.SemiTrust._ButtonEventSink_SinkHelper.OnClick(DocActionEvent pEvent)
The code:
//Connect to secondary data source
DataSource ds = DataSources["RE_Tasks"];
XPathNavigator domNav = ds.CreateNavigator(); XPathNodeIterator rows = domNav.Select("/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW", NamespaceManager);
//Loop through secondary data source and populate the repeating table
while (rows.MoveNext())
{
string Title =
rows.Current.SelectSingleNode("Title", NamespaceManager).Value.ToString();
string ID =
rows.Current.SelectSingleNode("ID",NamespaceManager).Value.ToString();
string Closing =
rows.Current.SelectSingleNode("Closing", NamespaceManager).Value.ToString();
using (XmlWriter writer =
MainDataSource.CreateNavigator().SelectSingleNode("/my:MainDataSource/my:group4",
NamespaceManager).AppendChild())
{
writer.WriteStartElement("group5", myNamespace);
writer.WriteElementString("Closing",myNamespace ,Closing);
writer.WriteElementString("Title",
myNamespace, Title);
writer.WriteElementString("ID", myNamespace,
ID);
writer.WriteEndElement();
writer.Close(); }