InfoPath form with SQL Server and Visual Studio .NET

[rkellow]

Hello,

Is it possible to have an InfoPath form with a SQL Server data
connection (for submitting data to the database) and have that as a
Visual Studio .NET C# solution? I can't seem to create the data
connection (for submitting) in InfoPath when I make it a Visual Studio
solution. Does everything for the database need to be done in the C#
code instead of doing it in InfoPath or alternatively with a web
service?

Any help would be greatly appreciated.

Thanks in advance,
Rob

 

[Franck Dauché]

Hi,

You can do it either way.
The simple way to tackle this is to create a new IP form (with C# code
behind). On the IP menu bar, go to Tools / Data Connections / Add / Submit
Data / WebService.

Now, you could instead create your own submit button and call you Web
Service from C# code (bypassing the default submit feature from IP).

Franck Dauché