rayh 98086 (4/25/2013)

---

Hi,

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);

conn.Open();

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();

rdr.Close();

rdr.Dispose();