jwcolby
jwcolby at colbyconsulting.com
Mon Nov 30 11:44:39 CST 2009
While I am getting back values in my "output" parameters for the SPs, I am getting a constant -1 for the return value. In the stored procedure I have tried just using RETURN 1234 and also creating an int variable, setting that to 1234 and returning that. declare @Ret int select @ret = 1234 RETURN @ret In all cases I get a -1 value which leads me to believe that the problem is on the C# side of things. My c# code looks like: try { if (sCmd.Connection.State != ConnectionState.Open) sCmd.Connection.Open(); int retValue = sCmd.ExecuteNonQuery(); return retValue; } catch (SqlException sqlEx) { throw sqlEx; } I am not throwing an error, the SP executes, but retValue is always -1. Any ideas? Do I need to add a SqlParameter to the Parameters collection for the return value? -- John W. Colby www.ColbyConsulting.com