Hi all,
I am using @foreach(var row in selectedData){::creates table for each result::} to show results from a search form. The SQL table has 7 fields. Currently, the site returns every row that matches the search in a new table created by @foreach. However,
a lot of the rows are duplicates - except for one field.
Any ideas on how I would group the duplicate search results into a single table and only list the fields that are different in the table (as opposed to a new table for each result)?
For instance, in the following search results, I would only want one table that lists all of the different locations:
Search Results
In other words, I would want:
Go to the complete details ...