InfoPath Dev

I have an InfoPath form. One of it's fill out fileds is: "IDnumber"
I want that after the user enter the IDnumber, It will searching for this IDnumber in the SQL server DB and will return answer if it exist in the SQL DataBase (I know I need to operate OnAfterChange Event).

I dont need the code for this I just want to know the best way to this:

Must notice that:
1) I desgined the form from a New Blank Form (not from data connection).
2) My form can be .NET project (c#) or regular form designer (Code in script editor)

I will give some leading question
1) should I create (case of .NET code) a web referernce to a WEb Service that contain method that check it, and to operate the WS from the form's code (by the Web Refernce object)?

2) should I create Data Connection to the specific method of the WS that check it (case of not .NET project or .NET project) and to operate this Data Connection from the form's code (VBscript or Javascript or c#). If yes so I want to know which type should the Data Connection be (Submit or Recive)? How to operate this Data Connection from the code (need code Example)?

3) Can I do it without WS? How?

I'm asking this because:
1) I want to avoide built my project in .NET (I dont want the users to install .NET Framework on their machins).
2) In order to do 1 I need to avoid adding Web Reference (to a WS)
3) I want to avoid give my form a Full Trust Security (and if I use Web Refernce I will need to do this) since I dont want to install it on each machin or to sign it!

Must Help and answers!!

Hi Liorlankri,

As specified in case2, u should create a Dataconnection to the web service.And u should create a "Receive" data connection to ur web service.

By using "Receive" dataconnection,u will be able to send data from ur form to the webservice and also receive data from ur webservice.

And regarding ur 3rd question, u cannot do it without using a webservice becoz u donot have an option to query the database when u establish a "Receive" data connection to it.

Now to avoid installing .NET framework in users machine, write JScript code to query the "Receive" dataconnection to ur webservice.

When querying, donot forget to pass the "IDNumber" to ur queryfield in ur secondary datasource.

regards,
Abhishek

Thank you Abhishek!
You help me a lot
Now I need code example (in JavaScropt or VBscript) to query the "Receive" dataconnection to my webservice.
Can you help me with this??

By the way!
Can I do it by using ADOAdapter Object of InfoPath (without using web service)?

Hi Liorlankri,
This is the code to query the receive data connection to a web service.It also shows u how to send a input parameter to the web service.

It is in C# though.For JScript, it requires very minor modifications.

IXMLDOMDocument3 wsDOM = IXMLDOMDocument3)thisXDocument.DataObjects["<DataConnection Name>"].DOM;

//Set the SelectionNamespaces so that you can find the correct field
wsDOM.setProperty("SelectionNamespaces","xmlns:dfs=\"http://schemas.microsoft.com/office/infopath/2003/dataFormSolution\""
+ " xmlns:tns=\"http://tempuri.org/\"");

//Set Web Service input parameters
wsDOM.selectSingleNode ("/dfs:myFields/dfs:queryFields/tns:FindADSUsers1/tns:FirstOrLastName").text =e.Source.selectSingleNode("my:RoleApproverEditable").nodeTypedValue.ToString();

//Requery the webservice datasource
thisXDocument.DataObjects["<DataConnection Name>"].Query();

Now in JScript, u need to do minor modifications like
replace "thisXDocument" needs to be replaced by "XDocument".

So the final requerying the webservice statement would be like...

XDocument.DataObjects("Name of your Data Connection").Query();

regards,
Abhishek

O.K! Thank you.
But I need to get a value back. How to cath it? can I do
bool Val=XDocument.DataObjects("Name of your Data Connection").Query(); ?

U dont have to do that.
Just go to ur datasource task pane.Select ur secondary datasource in the dropdown.
U can find all the datafields.U just need to drag that field to ur form.

But data in the secondary data source is not saved when u save or submit the form.
So u can transfer it to ur main data source if u need it to be saved in the form's xml when u save the form.

Regards,
abhishek

I have defenition problem
dataDom.setProperty ("SelectionNamespaces","xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution"" "xmlns:tns="http://tempuri.org/"")

I get error this
"Expected end of statement"
What's not good?

What should be the "dfs" defenition and the "tns" defenition??

hi,
Open the Manifest.xsf in a text editor.
U can find the "dfs" or "tns" defns there.
Expected end of statement is becoz u have not given a semicolon at the end of that particular line.
regards,
Abhishek

I still dont understand the correct syntax to this line

dataDom.setProperty "SelectionNamespaces", "xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution"" "xmlns:tns="http://tempuri.org/""

I get error this
"Expected end of statement"
How to fix it? what's the syntax?

Hi,
I have taken an example from the SDK.
Just compare ur syntax with this one.May be u have gone wrong somewhere with the double quotes and single quotes.

XDocument.GetDOM("Customers (USA)").setProperty("SelectionNamespaces",
'xmlns:q="http://schemas.microsoft.com/office/infopath/2003/ado/queryFields" ' +
'xmlns:d="http://schemas.microsoft.com/office/infopath/2003/ado/dataFields" ' +
'xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution"');
objCustomerLookupNode = XDocument.GetDOM("Customers(USA)")
.selectSingleNode( "//d:Customers[@CustomerID='" + strCustomerId + "']");

Take a look at the single Quotes and double Quotes.


Take a look at the following link
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ipsdk/html/ipsdkWorkingSecondaryInILForm_HV01074927.asp

regards,
Abhishek.

It's work!!!!

Thank you