Infopath through WCF

Posted on 2012-08-30
Last Modified: 2015-09-28
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,
Question by:ccroasmun
    1 Comment
    LVL 28

    Accepted Solution

    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, they can do all you describe and have documentation or can show you a demo.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
    Work Over Net is a new and very powerful collaboration product. With its new easy interface it is becoming very competitive to other similar products like webex and office interactive. WON 2010 have the standard business tools needed for multi-offic…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now