InfoPath Dev

 Hello-

 I have been trying to get a form to use a data connection and execute a SELECT statement to get a value, then put that value on a form. I know this isn't difficult but I cannot see what I am missing. Here is my code - I think it is pretty self explanatory:

public void CTRL645_5_Clicked(object sender, ClickedEventArgs e)

XPathNavigator MDMid = CreateNavigator().SelectSingleNode("/my:myFields/my:sectCommon/my:MDMid", NamespaceManager);

XPathNavigator custName = CreateNavigator().SelectSingleNode("/my:myFields/my:sectCommon/my:custName", NamespaceManager);

XPathNavigator RetCustName = CreateNavigator().SelectSingleNode("/dfs:myFields/dfs:dataFields/d:DAL_PARTY/@CUST_NAME", NamespaceManager);

string MDMidNum = MDMid.InnerXml;

AdoQueryConnection myAdoQueryConnection = (AdoQueryConnection)(this.DataConnections["DAL_PARTY"]);

myAdoQueryConnection.Command = "select CUST_NAME from [DAL_PARTY] where [ROWID_OBJECT] = " + MDMidNum;

I am receiving a null object exception on the last line, but I copied the XPath and pasted it. What could I be missing? I know the data is there...

Thanks in advance,

-Drew

 Well - I'd expect you'd need to create a navigator for the secondary data source - I usually use MainDataSource.CreateNavigator() for main data source nodes and this.DataSources["DataSourceNameGoesHere"].CreateNavigator() for secondary data sources....

 Thanks Hilary - you're exactly right! I followed it to a namespace error and that got me thinking along those lines. I'll post the working code here in case it can be of help to anyone else in the future.

 Thanks again!

-Drew 

public void CTRL645_5_Clicked(object sender, ClickedEventArgs e)

XPathNavigator MDMid = CreateNavigator().SelectSingleNode("/my:myFields/my:sectCommon/my:MDMid", NamespaceManager);

XPathNavigator custName = CreateNavigator().SelectSingleNode("/my:myFields/my:sectCommon/my:custName", NamespaceManager);

string MDMidNum = MDMid.InnerXml;

AdoQueryConnection myAdoQueryConnection = (AdoQueryConnection)(this.DataConnections["DAL_PARTY"]);

myAdoQueryConnection.Command = "select CUST_NAME from [DAL_PARTY] where [ROWID_OBJECT] = " + MDMidNum;

XPathNavigator RetCustName = this.DataSources["DAL_PARTY"].CreateNavigator();

XPathNavigator ReturnedCustName = RetCustName.SelectSingleNode("//dfs:myFields/dfs:dataFields/d:DAL_PARTY/@CUST_NAME", NamespaceManager);