Custom Database Access with InfoPath 2007

[josepk]

Hello,

I'm working with InfoPath 2007 (Beta) and Visual Studio 2005. I would
like to use C# to create some custom SQL Server calls, for reading and
writing data, using existing SQL stored procedures.

When I call the SQLConnection.Open() method in the InfoPath 2007
"FormEvents_Loading()" event I get a
"System.Security.SecurityException" exception - most likely due to
security permissions not being setup properly with the form.

A couple of questions:

- How does one go about setting up security permissions in an InfoPath
2007 form such that .NET calls within the form will function properly
on a user's machine?

- I want to take advantage of existing SQL Server stored procedures to
populate the data in my InfoPath 2007 form. Is there maybe an easier
way to do this instead of coding it myself with C# SQL calls in the
InfoPath 2007 form?

- Are there any coding examples online showing C# and InfoPath 2007
integration that I could reference?

Thanks!

Joe

 

[josepk]

No - not sure how to set the form security level or sign with a
certificate - any pointers on how?

Also, can I use C# .NET code (e.g. custom DB calls) in my InfoPath 2007
form if I plan on keeping the form as "browser only" (i.e. the client
using the form would not have the InfoPath 2007 client installed)?

Thanks,

Joe

 

[Cocteau]

Tools, form options, security, simple as that