C#

private int callStoredProc(string fullPath, string type)
        {
            // File Type 1
            string connectionString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
            string strRowAffect;
            SqlConnection con = new SqlConnection(connectionString);
            try
            {
                con.Open();
            }
            catch (Exception e)
            {
                this.lstEventsOccurred.Items.Add("ERROR: Database Connection could not be established in callStoredProc(): " + fullPath);
                this.lstEventsOccurred.Items.Add("Exception Produced: " + e.Message.ToString());
                return -1;
            }
            SqlCommand command = new SqlCommand("the_StoredProcedureToCall", con);
            command.CommandType = CommandType.StoredProcedure;

            SqlParameter retVal = command.Parameters.Add("@Return_Code", SqlDbType.Int);
            retVal.Direction = ParameterDirection.ReturnValue;

            SqlParameter inputFileName = command.Parameters.Add("@InputFilePathName", SqlDbType.VarChar, 120);
            inputFileName.Direction = ParameterDirection.Input;
            inputFileName.Value = fullPath;
            
            SqlParameter fileType = command.Parameters.Add("@FileType", SqlDbType.VarChar, 120);
            fileType.Direction = ParameterDirection.Input;
            fileType.Value = type;
            this.lstEventsOccurred.Items.Add("Calling:" + command.ExecuteNonQuery().ToString());

            strRowAffect = command.ExecuteNonQuery().ToString();
            con.Close();
            return (int)retVal.Value;
        }