Object reference not set to an instance of an object

[swathi]

Hi,
I am trying to connect to the db from infopath form through code.I wrote the
following code.
DataSource dscustomer = this.DataSources["CustomerNextNumber"];
XPathNavigator xnCustomer = dsCustomer.CreateNavigator();
XPathNavigator CustID =
xnCustomer.SelectSingleNode("/dfs:myFields/dfs:queryFields/d:CustomerNextNumber/d:CustID", NamespaceManager);
string strCustID = CustID.Value; // Read
CustID.SetValue(strApqpNbr);

At runtime, I am getting the NullReference Exception as follows.
"Object reference not set to an instance of an object"

How to resolve this.
Thanks

 

[swathi]

sorry, in last line it is strCustID.

CustID.SetValue(strCustID);

 

[David Dean]

There's no way to tell for sure from your code, but the null object reference
is probably occurring on the CustID variable because of a failure in
resolving the XPath expression. This may possibly be due to a case mismatch
or to using a different namespace prefix than InfoPath is expecting.

To double-check the XPath expression, go to the Data Sources pane, select
your CustomerNextNumber data source, expand the nodes to show your CustID
field, then select the "Copy XPath" option from the field's dropdown menu.
Then paste it into your code and compare.

--
David Dean
Sr. Member Technical Staff
Insource Technology Corp.

sorry, in last line it is strCustID.

CustID.SetValue(strCustID);

Hi,
I am trying to connect to the db from infopath form through code.I wrote the
following code.
DataSource dscustomer = this.DataSources["CustomerNextNumber"];
XPathNavigator xnCustomer = dsCustomer.CreateNavigator();
XPathNavigator CustID =
xnCustomer.SelectSingleNode("/dfs:myFields/dfs:queryFields/d:CustomerNextNumber/d:CustID", NamespaceManager);
string strCustID = CustID.Value; // Read
CustID.SetValue(strApqpNbr);

At runtime, I am getting the NullReference Exception as follows.
"Object reference not set to an instance of an object"

How to resolve this.
Thanks