private int getProfileID(string subString) { int retValue = -1; try { string stmt = "select profile_id from PROFILE_REP where upper(PROFILE_NAME) like '%" + subString.ToUpper() + "'"; SQLTransaction transaction = new SQLTransaction(this.session, APP_CODE, stmt); foreach (SQLRow row in transaction.GetResultRows()) { retValue = Convert.ToInt32(row.GetColumn(0)); break; } return(retValue); } catch (Exception ex) { HConsole.WriteError(ex); return(retValue); } }