uc : ide'en er god, men jeg får nu problemet at jeg ikke har declaret min webcontrol.
jeg er stadig lidt begynder :) så kommentare omkring dårlig opbygning vil jeg da ikke feje af vejen. Her kommer min nested repeater og de 2 funktioner som fylder data i.
Function BindOrderListe()
dbconnection.Open()
dim madDataset As New DataSet
dim strSql As String = "SELECT ordreid, Dato, lev_tid as [Tid], antalbestillinger as [Antal], Spisested, Ansvarlig FROM MadOrdre"
dim dbdataadapter As OleDbDataAdapter = New OleDbDataAdapter(strSql,dbconnection)
dbdataadapter.Fill(madDataset, "MadOrdre")
ordre.DataSource = madDataset.Tables("MadOrdre")
ordre.DataBind()
dbconnection.Close()
End Function
Function BindChildOrderListe(ByVal intPK As Integer) As DataSet
dim underMadDataset as new DataSet
dim strSql As String = "SELECT * FROM underMadOrdre WHERE ordreid =" & intPK
dim dbdataadapter As OleDbDataAdapter = New OleDbDataAdapter(strSql,dbconnection)
dbdataadapter.Fill(underMadDataset, "underMadOrdre")
tilfoejordre.Navigateurl = "tilfoejordre.aspx?ordreid=" & intPK
Return underMadDataset
End Function
<---------------------------------------------
<asp:Repeater id="ordre" runat="server">
<HeaderTemplate>
<table class="datatable" cellpadding="0" cellspacing="0">
<tr>
<td width="40">
<img border="0" src="../images/opnbookr.gif" width="24" height="22" /></td>
<td width="90">
Dato</td>
<td width="50">
Tid</td>
<td width="50">
Antal</td>
<td width="100">
Spisested</td>
<td width="100">
Ansvarlig</td>
<td width="160">
Funktioner</td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td>
<img border="0" src="../images/noder.gif" width="16" height="22" /><img border="0" src="../images/txtdoc.gif" width="24" height="22" /></td>
<td>
<%# DataBinder.Eval(Container.DataItem, "dato") %></td>
<td>
<%# DataBinder.Eval(Container.DataItem, "tid") %></td>
<td>
<%# DataBinder.Eval(Container.DataItem, "antal") %></td>
<td>
<%# DataBinder.Eval(Container.DataItem, "spisested") %></td>
<td>
<%# DataBinder.Eval(Container.DataItem, "ansvarlig") %></td>
<td>
<asp:HyperLink runat="server" navigateurl='<%# DataBinder.Eval( Container.DataItem, "ordreid", "java script:switchVisible({0});" ) %>'>vis</asp:hyperlink>
|
<asp:HyperLink runat="server" navigateurl='<%# DataBinder.Eval( Container.DataItem, "ordreid", "?ordreid={0}" ) %>'>ret</asp:hyperlink>
</td>
</tr>
<tr>
<td colspan="7" class="struktur_backline">
<table class="datatable" id='<%# DataBinder.Eval(Container.DataItem, "ordreid") %>' style="display: none;">
<tr>
<td>
<asp:Repeater runat="server" DataSource='<%# BindChildOrderListe(Ctype(DataBinder.Eval(Container.DataItem,"ordreid"), Integer)) %>'>
<HeaderTemplate>
<table class="datatable" cellpadding="0" cellspacing="0">
<tr>
<td width="12"></td>
<td width="40" class="struktur_backline"></td>
<td width="100">
Ejer</td>
<td width="100">
Bestilling</td>
<td width="100">
Kommentar</td>
<td width="100">
&</td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td></td>
<td>
<img border="0" src="../images/noder.gif" width="16" height="22" /><img border="0" src="../images/txtdoc.gif" width="24" height="22" /></td>
<td>
<%# DataBinder.Eval(Container.DataItem, "ejer") %></td>
<td>
<%# DataBinder.Eval(Container.DataItem, "bestilling") %></td>
<td>
<%# DataBinder.Eval(Container.DataItem, "kommentar") %></td>
<td>
<%# DataBinder.Eval(Container.DataItem, "underOrder") %></td>
</tr>
</ItemTemplate>
<FooterTemplate>
<tr>
<td><asp:HyperLink runat="server" id="tilfoejordre">tilfoej ordre</asp:HyperLink></td>
</tr>
</table>
</FooterTemplate>
</asp:Repeater>
</td>
</tr>
</table>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
<tr>
<td>
<img border="0" src="../images/lstnoder.gif" width="16" height="22" /><img border="0" src="../images/txtdoc.gif" width="24" height="22" /></td>
<td colspan="6">
<a href="ordre.aspx">opret ny ordre</a></td>
</tr>
</table>
</FooterTemplate>
</asp:Repeater>
