InfoPath Dev

Hello there, I have 3 connected dropdown lists in my Infopath form. Selecting values from the first dropdown filters the entries in the second one and selecting a value in the second one will filter the entries of the third one. When selecting a value the second dropdown I get the "Object reference not set to an instance of an object" error. Despite of this error the form works just fine. It even retrieves the right values, but through the error it will not work as a browser form. Everything is located in my Main data source which you can see on the left side.

When changing the second dropdown the function

public void Artikelnummer_Changed(object sender, XmlEventArgs e)

will be called.

The pointer is now located at Artikelnummer. I want to retrieve the values for tempFarbe, but only if ddArtikelnummer matches Artikelnummer:

XPathNavigator xnFarben = e.Site.SelectSingleNode("..//my:tempFarbe[../my:ddArtikelnummer = ../../../my:Artikelnummer]", NamespaceManager);

When I now try to use the xnFarben object, I get the "Object reference not set to an instance of an object" error. When I move on the right values are in:

Could you show us the line of code that is generating the error, and perhaps a bit more of the code above and below it?

Hi,

Since it is an Xpath issue we cant figure it out without knowing your main schema.So provide your schema so i can definitely help you.

try

//MessageBox.Show(e.Site.SelectSingleNode("//my:tempFarbe[../my:ddArtikelnummer = ../../../my:Artikelnummer]", NamespaceManager).OuterXml);

XPathNavigator xnFarben = e.Site.SelectSingleNode("..//my:tempFarbe[../my:ddArtikelnummer = ../../../my:Artikelnummer]", NamespaceManager);

char[] split = {';'};

List<XPathNavigator> nodesToDelete = new List<XPathNavigator>();

//delete all nodes on the list

"<my:ddFarbeText>"+ aFarben[i] +"</my:ddFarbeText></my:ddFarbe>";

That code seems ok, but can you guarantee that the XPath "..//my:tempFarbe[../my:ddArtikelnummer = ../../../my:Artikelnummer]", will always find a matching node(i.e., that there will always be a child ddArtikelnummer that matches the grandparent Artikelnummer)?  If not, that error is going to occur.

 Does the stack trace that you are showing in the message box provide line numbers, and if so, which line in the code above is it pointing out as the line where the error occurred?

There are 3 drop down list in my form. The first lets you select a category, with this you will be able to select the articles of this category and through selecting an article you can select a color. The error occurs every time, if there are colors for an article or not.

Artikelnummer is the value, which was selected from the dropdown. ddArtikelnummer are the values with which the dropdown list was filled.

So there has to be always a matching one. tempFarbe is not filled every time, because not every article has a color, but that should not be the problem.

 The stack trace points to the line where I use the xnFarben object for the first time, which is line 307 String sFarben = xnFarben.InnerXml; in my code. But the string holds the correct value afterwards.

Are there any other ideas  regarding my problem ?

Hi,

Try the following code.

XPathNavigator xnFarben = e.Site.SelectSingleNode("..//my:tempFarbe[../my:ddArtikelnummer = ../../../my:Artikelnummer]", NamespaceManager);

If(xnFarben == null)

{

return;

}

String sFarben = xnFarben.InnerXml;

Write the next code lines.

Ah nice, thank you. It works now fine in the Infopath, but I get the following error when viewing the form in the browser.

 Unexpected end of file while parsing Name has occurred. Line 1, position 557.

System.Xml.XmlException: Unexpected end of file while parsing Name has occurred. Line 1, position 557.
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.Throw(String res, String arg)
at System.Xml.XmlTextReaderImpl.Throw(Int32 pos, String res, String arg)
at System.Xml.XmlTextReaderImpl.ParseQName(Boolean isQName, Int32 startOffset, Int32& colonPos)
at System.Xml.XmlTextReaderImpl.ThrowTagMismatch(NodeData startTag)
at System.Xml.XmlTextReaderImpl.ParseEndElement()
at System.Xml.XmlTextReaderImpl.ParseElementContent()
at System.Xml.XmlTextReaderImpl.Read()
at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace)
at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)
at System.Xml.XmlDocument.Load(XmlReader reader)
at Microsoft.Office.InfoPath.Server.Xml.InfoPathXmlDocument.Load(XmlReader reader)
at Microsoft.Office.InfoPath.Server.DocumentLifetime.DataObject.<>c__DisplayClass3.<.ctor>b__0()
at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock)
at Microsoft.Office.Server.Diagnostics.ULS.SendWatsonOnExceptionTag(ULSTagID tagID, ULSCat categoryID, String output, Boolean fRethrowException, TryBlock tryBlock, CatchBlock catchBlock, FinallyBlock finallyBlock)
at Microsoft.Office.InfoPath.Server.DocumentLifetime.DataObject..ctor(EnhancedBinaryReader reader, Solution solution)
at Microsoft.Office.InfoPath.Server.DocumentLifetime.DataObjects.<>c__DisplayClass2.<.ctor>b__0(EnhancedBinaryReader innerReader, DataObject& newObject)
at Microsoft.Office.InfoPath.Server.Serialization.EnhancedBinaryReader.ReadObjectMap[KeyT,ValueT](Dictionary`2 map, ItemReaderDelegate`1 readKey, ItemReaderDelegate`1 readValue)
at Microsoft.Office.InfoPath.Server.Serialization.EnhancedBinaryReader.ReadObjectMap[ValueT](Dictionary`2 map, ItemReaderDelegate`1 readValue)
at Microsoft.Office.InfoPath.Server.DocumentLifetime.DataObjects..ctor(EnhancedBinaryReader reader, Solution solution)
at Microsoft.Office.InfoPath.Server.DocumentLifetime.DocumentSessionState.DesterilizeVersion1(EnhancedBinaryReader reader, Solution solution)
at Microsoft.Office.InfoPath.Server.DocumentLifetime.DocumentSessionState..ctor(EnhancedBinaryReader reader, Solution solution)
at Microsoft.Office.InfoPath.Server.DocumentLifetime.DocumentSessionState.CreateFromByteArray(Byte[] serializedSessionState, Byte[] serializedVersionState, Solution solution)
at Microsoft.Office.InfoPath.Server.DocumentLifetime.DocumentSessionStateManager.GetSessionState(HttpContext context, String editingSessionID, Solution solution)
at Microsoft.Office.InfoPath.Server.DocumentLifetime.Document.LoadFromSession(HttpContext context, SPSite contextSite, EventLogStart eventLogStart, Solution solution)
at Microsoft.Office.InfoPath.Server.Controls.PostbackPage.<>c__DisplayClass1.<ProcessRequest>b__0()

Edit: Forget about that. I had an unused secondary Dataconnection.

Thanks again to all who gave advice.