Is there a way to do the following:
My repeater data source has 3 fields. Department, Employee, and
StartDate, and is sorted by Department. I want to use the repeater to
get the following layout:
Accounts
John Smith 12/12/2003
Mary Watson 04/05/2001
Training
Sue Jones 11/10/2004
etc.
I have an idea of how the code would look:
strDepartment = "" 'somewhere in page load
<itemTemplate>
If datasource("Department") <> strTemplate Then
<tr>
<td colspan="2">output the department field</td>
</tr>
strDepartment = datasource("Department")
End If
output the Name and startdate in a tr td etc
The problem is I cannot find a way to refer to the datasource
department field to compare against the strDepartment.
Any ideas.
Thanks