I'm sort of new to web forms but i hope anyone of you would be able to advise me on how to tackle this:
I have the following table in the database:
ID | Name | ParentId
1 | music | 0
2 | house | 1
3 | urban | 1
4 | games | 0
5 | ps4 | 4
2 | Xbox | 4
*code behind the Aspx page: I'm just returning a list of the table here like this:
protected List<EventsTable> events;
events = db.EventsTable.ToList();
*Aspx Page: on this page i need to list all the events in table. for example; i need to list a parent Event and its child events below . i.e * music (parent) house urban *games(parent) ps4 xbox
This is what i have done so far. As i mentioned i'm new to web forms but i have experience in MVC , so i'm trying to use the Aspx page as i would in a view in MVC. I have a table like so:
<table class="table">
<tr>
<th>Event</th>
<th>Edit</th>
</tr>
<%foreach(var s in events) {%>
<tbody>
<tr>
<%if (s.ParentId == 0)
{%>
<td> * <%= s.Name %></td>
<%} %>
<td> <%= s.Name %></td>
<td> <a> Edit</a></td>
</tr>
</tbody>
<%}%>
</table>
Could someone please direct me on how I would go about in listing the events in the way I've said above? I'm not sure what the best option would be for me to achieve this in web forms.