How to get SQL Server stored procedure output parameter C#

Question

I have this code so how to get out parameter value here...

string Proc_CreateWorkingSet = "usp_CustomerInfo";

var parameters = new[] {
          new SqlParameter(){ ParameterName="@WorkTableName", Value="WorkingSet" },
          new SqlParameter(){ ParameterName="@ProcessName", Value=Customer.ProcessName },
          new SqlParameter(){ ParameterName="@SettingName", Value="NORTHSHOREMISCFIELD" },                            
          new SqlParameter(){ ParameterName="@ReturnedSQLCmd", Value=string.Empty, Direction=ParameterDirection.Output},
         };

ClientDatabase.ExecuteStoredProcedureNonQuery(Proc_CreateWorkingSet, parameters);
Logger.LogInfo(parameters[3].Value.ToString());

The problem most probably lies in your customized ExecuteStoredProcedureNonQuery which does something with parameters. No other ideas yet. — Alex Kudryashev
– Alex Kudryashev, Commented Jul 1, 2016 at 20:52

Rahul · Accepted Answer · 2016-07-01 20:40:11Z

3

Just use the Value property like below. ToString() returns the parameter name and not value

Logger.LogInfo(parameters[3].Value);

answered Jul 1, 2016 at 20:40

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to get SQL Server stored procedure output parameter C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related