May 25, 2017

Working with an SQL Output Parameter in C#

When working with an SQL Output parameters, you need to specify the parameter’s Direction property once you have created it. Here is a nice little example method: private float checkValue() { SqlConnection con = new SqlConnection(“Provider=PROVIDER;Server=SERVER;Database=DATABASE;”); SqlCommand com = new SqlCommand(“getValue”, con); com.CommandType = CommandType.StoredProcedure; SqlParameter par = new SqlParameter(“@WB”,