using(SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection | CommandBehavior.SingleRow)) { if(dr.Read()) { return (int)cmd.Parameters[(int)TRAINING.p_Customer_ins_Parameters.rv_RETURN_VALUE].Value; } return -1; }