public static string GetScientificName(int record_id) { SqlCommand command = new SqlCommand(); command.CommandText = "SELECT SCIENTIFIC FROM [MARINE_SPECIES] WHERE [ID_PK] LIKE @RECORD_ID"; command.Parameters.AddWithValue("@RECORD_ID", record_id); return(DAOHelper.RetreiveString(command)); }