SQL Database Integration

Re: How do you set a C# variable from an SQL query

HaydenLewin — Tue, 02 Dec 2014 01:22:18 GMT

Thanks for the reply .. I did as you said but struck another problem. The SQL references a view and the XPath referenced the same view.

However, that continually threw up a Null exception ...

the xpath from InfoPath for the field is

/dfs:myFields/dfs:dataFields/d:vwPersonInfo/@MyOid

however, after a bit of hair pulling we realised that the SelectSingleNode didn't cope with a view and wanted a table, so we had to reference the original table

/dfs:myFields/dfs:dataFields/d:tbEmployee/@MyOid

All good now the form is working as it should

Re: How do you set a C# variable from an SQL query

Hilary Stoupa — Mon, 01 Dec 2014 19:34:07 GMT

Hi!

Since you are using a data connection in your form for this, you won't need too much magic, only a little.

You'll need the XPath to the field in the data connection that will have the value - does that field show in the data source task pane?

To get data from your secondary data connection:

this.DataSources["GetOID"].CreateNavigator().SelectSingleNode("XPATHGOESHERE", NamespaceManager).Value;

How do you set a C# variable from an SQL query

HaydenLewin — Mon, 01 Dec 2014 01:27:14 GMT

I have a Form Load event that triggers ...

Using a webservice I get the GUID of the active employee ... I want to use this information to Query a table to get an "OID" for that user for use in further queries ..

//Get the GUID of the current employee

string strGUID = xnMain.SelectSingleNode("/my:myFields/my:GUID", ns).Value;

//Declaure the strOID;

string strOID = null;

//Execute query to get the OID of the User;

AdoQueryConnection dsSQL = (AdoQueryConnection)this.DataConnections["GetOID"];

string strOrigSQL = dsSQL.Command;

dsSQL.Command = "select oid from odb3.vwPersonInfo where employeeguid = '" + strGUID + "';";

dsSQL.Execute();

//Need magic code here;

I need the code that allows me to set strOID = the returned value of the SQL Query

Can anyone help me out?