InfoPath Dev

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.

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

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

var result = XDocument.QueryAdapter.????

Many Thanks

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

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

Agni
InfoPath Dev India