[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 92
  • Last Modified:

Infopath through WCF

I have another question posted which isn't getting the response I hoped, so I'm going to hopefully simplify my question here as if I can validate that I will be able to accomplish the following requirements, I have no problem doing the Visual Studio work.

- Can I have multiple SQL Server 2008 data sources in an InfoPath 2010 WEB form, Some read only for lookups, and 1 main source to write and update to a table through a WCF or some other type of web service?

- If yes, is WCF the proper service to learn how to create, or is there a better approach?

- If no, how is the best approach for this, pure C# server side before the submit or am I totally off base.

- Although I think I know this answer is no, is there a way to do it natively in InfoPath that I'm missing, these are WEB forms, not client based.

- At this point in time I have no budget for third party tools or solutions, and I have found many solutions that would expedite this, so these answers are a no go for me, although free tools like xml editors, query editors, or any other suggestions to make this effort easier on me would be appreciated.

Thanks in advance,
Chuck
0
ccroasmun
Asked:
ccroasmun
1 Solution
 
clayfoxCommented:
Hey Chuck.

This can be done, if you have the right components

If you want to have the infopath form webbased you have to go with web services.  Also if you want to be able to query even the lookup data.

check out www.qdabra.com, they can do all you describe and have documentation or can show you a demo.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now