output param in SP, tableadapter

microsoft.public.dotnet.framework.adonet

28 Mar 2006 3:09 PM

David R

I have a stored procedure with a number of input parameters, and one output
parameter (integer type). I call the stored procedure from a table adapter
in a typed dataset. The table adapter's method used (I'll call it
sp_getdata) is configured to receive a single value from the SP. I
understand that behind the scenes, the table adapter code handles the one
output parameter as a reference type. Because I get design-time errors that
I cannot convert from int to ref int?, I create a new integer variable (int
var) , and pass it in as a reference (ref var). Now I get the error that I
cannot convert from 'ref int' to ref int?' Can anyone make sense of this?

One more thing. I can calling sp_getdata either of the following two ways

int retval;
int spval;

tableadapter.sp_getdata(var1, var2, var3, var4, ref spval);
retval = spval;

as well as

int retval;
int spval;

retval = tableadapter.sp_getdata(var1, var2, var3, var4, ref spval);

Thanks,

David