I am trying to pull a return a single value from a stored procedure, but cannot seem to find the correct logic.
Can someone share with me help me with my code and tell me where I would put the return value?
conn = new SqlConnection(Test_Utility.Properties.Settings.Default.ConnectionString);
SqlCommand cmd = new SqlCommand("sp_UploadFile", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@RunNo", theRunNo));
cmd.Parameters.Add(new SqlParameter("@getFileName", txtFileToProcess.Text));
rdr = cmd.ExecuteReader();