Cannot implicitly convert type object to int.  An explicit conversion exists

I am trying to setup a test value before an if statement is evaluated.  I need to know the returned value for a database read but I guess I do not understand how to pull the value correctly.  Can someone guide me in the correct way to do this?

Thanks
Kenny


GetRefIdConn.Open();

        cmd = new SqlCommand("GetCurrentReferralID", GetRefIdConn);
        cmd.CommandType = CommandType.StoredProcedure;


        // Input Parameters
         cmd.Parameters.Add("@pType", SqlDbType.VarChar, 100).Value = "Referral Queue ID";
         cmd.Parameters.Add("@pIncrement", SqlDbType.Int, 4).Value = 5;
       
       //  Output Parameters
         cmd.Parameters.Add(new SqlParameter("@pNewId", SqlDbType.Int, 4));
         cmd.Parameters["@pNewId"].Direction = ParameterDirection.Output;


       
    //    execute the command and read the current Referral ID
         cmd.ExecuteNonQuery();


        //get the value out

         int test = cmd.Parameters["@pNewId"].Value;    -------------   error occurs here

        if (cmd.Parameters["@pNewId"].Value != DBNull.Value)

        {
            ReferralId = Convert.ToInt32(cmd.Parameters["@pNewId"].Value);
            cmd.Parameters.Add("@REFERRAL_QUEUE_ID", SqlDbType.Int).Value = ReferralId;

        }
        else
            ReferralId = 0;
     
Start Free Trial