Code

Re: Stored Procedure Ouptut Parameters

Agni Jonnalagadda — Thu, 04 Aug 2005 14:55:38 GMT

Hi Bobstery, Sorry for being late, here is teh code to access data adapters

//C# code
thisXDocument.DataAdapters["DataConnectionName"]

Agni
InfoPath Dev India

Re: Stored Procedure Ouptut Parameters

bobstery — Mon, 25 Jul 2005 08:24:07 GMT

How would I access the result in the script i.e.

var result = XDocument.QueryAdapter.????

Many Thanks

Re: Stored Procedure Ouptut Parameters

Agni Jonnalagadda — Wed, 20 Jul 2005 19:34:59 GMT

Hi bobstery,
How did you call the stored procedure? I have written a simple example, where i could get the out parameter. Just check out whether this works for you
declare @abc varchar(10)
exec dbo.outparameter @abc out
select @abc as abc

I have given this sql statement when i was taking sql data connection.

Check out if this helps!

Agni
InfoPath Dev India

Stored Procedure Ouptut Parameters

bobstery — Wed, 20 Jul 2005 10:16:41 GMT

Does anybody know how to access the Ouput parameters of a Stored Procedure called through Infopath? I can successfully call the Stored Procedure but cannot access the Output parameters.