SQL Database Integration

Re: Retrieving and populating a form value from a SELECT statement

aebailey40 — Wed, 25 Sep 2013 02:19:29 GMT

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;

myAdoQueryConnection.Execute();

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

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

custName.SetValue(ReturnedCustName.InnerXml);

}

Re: Retrieving and populating a form value from a SELECT statement

Hilary Stoupa — Wed, 25 Sep 2013 00:58:21 GMT

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....

Retrieving and populating a form value from a SELECT statement

aebailey40 — Wed, 18 Sep 2013 15:09:57 GMT

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;

myAdoQueryConnection.Execute();

custName.SetValue(RetCustName.Value);

}

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