Data Connections

Re: InfoPath - Calling Stored Procedure with parameters from C#

Hilary Stoupa — Tue, 01 Jul 2008 14:28:34 GMT

A web service is a great way to go, and Qdabra's DBXL can help you with this and much more. However, you can use a .config file in your C# project to store your authentication information, and call that in your code, so that you do not need to store your authentication information. This post has some information about using a .config file: http://www.infopathdev.com/forums/p/8167/29809.aspx#29809

Re: InfoPath - Calling Stored Procedure with parameters from C#

zero77 — Tue, 01 Jul 2008 01:46:57 GMT

Thanks for both your replies.

I think I should've been clearer.

My problem is that I wish to create a Data Link File (so that authentication is done there). This is because I have heard that embedding the authentication within custom code raises a security issue. The following article appears to explain what i want to do. However, it does it in script and I want to do this in C#: http://support.microsoft.com/kb/827007

I think I might just have to use a web service as was advised?

Re: InfoPath - Calling Stored Procedure with parameters from C#

Hilary Stoupa — Mon, 30 Jun 2008 21:26:21 GMT

Hello:

Here is a link to a code sample that creates a Sql connection in code: http://www.sharepointblogs.com/ssa/archive/2006/01/03/populating-infopath-fields-with-sql-data-using-managed-code.aspx

Where this code has the command "select * from tblUser" you could easily replace with "execute sp" etc. If you want to get your parameter value from form field and use that value for your parameter, you can do something like this:

string xpath = "/my:myFields/my:textField";
XPathNavigator field = MainDataSource.CreateNavigator().SelectSingleNode(xpath, NamespaceManager);

and then use field.Value in your sql command for your parameter value. If your form is defaulting to vb.net and you'd prefer C#, you can change that in Tools/Form Options under the programming tab.

Re: InfoPath - Calling Stored Procedure with parameters from C#

Clay Fox — Mon, 30 Jun 2008 14:00:08 GMT

Have you looked at using a web service instead?

This is best practice rather than hardcoding each InfoPath form with code.

Qdabra has some installable ones to get you going immediatly or for reference.

DBXL v2.2 Beta Edition

InfoPath - Calling Stored Procedure with parameters from C#

zero77 — Mon, 30 Jun 2008 09:40:45 GMT

To anybody that can help,

Objective: I want to pass through parameters to an SQL Server 2005 stored procedure from an InfoPath field.

Problem: How to do this within the Change Event of the field using C# or VB?

A bit of background:

I have installed Microsoft .NET Framework 3.0 and Visual Studio

What this means is that whenever I try to insert code into the Change Event of the field (which contains the parameter value), it loads up Microsoft Visual Basic for applications environment. I found this article which explains this:

http://msdn.microsoft.com/en-us/library/bb250982.aspx

Additionally, I have found this article that at first glance appears to do what I want:

http://support.microsoft.com/kb/827007

The problem with this is that it uses a script within Microsoft Script Editor.

Help please