wrong number of entries

elad1988

The datatable shows wrong number of entries (2 instead of 11), the main problem is that the paging and sorting doesn't work.
The table is nested in a repeater asp.net control, and the information is obtained from the sqlServer (using the cs code behind)

The aspx code is:

'''

          <asp:Repeater ID="rptIncomeOutcome" runat="server">
            <HeaderTemplate>
                <table class="tbl" id="tblIncomeOutcome" style="margin:auto" dir="rtl">
                    <thead>
                    <tr style="background-color:#167F92; color:white">
                        <td>תאריך</td>
                        <td id="amountTd" runat="server">סכום</td>
                        <td>תיאור</td>
                        <td>edit</td>
                        <td>delete</td>
                    </tr>
                        </thead>
            </HeaderTemplate>
            <ItemTemplate>
                <tbody>
                <tr runat="server" style="font-family:Arial;font-size:16px; background-color:#D9E4E6;border-color:transparent">
                    <td><asp:Literal ID="ltrlDate" runat="server"></asp:Literal></td>
                    <td><asp:Label ID="ltrlAmount" runat="server"></asp:Label></td>
                    <td><asp:Literal ID="ltrlDescription" runat="server"></asp:Literal></td>
                    <td><asp:ImageButton ID="btnEdit" runat="server" Text="ערוך פריט" CommandName="EditIncomeOutcome" ImageUrl="images/editBtnImg.png" Height="26px" /></td>
                    <td><asp:ImageButton ID="btnDelete" runat="server" Text="מחק פריט" CommandName="DeleteIncomeOutcome" ImageUrl="images/deleteBtnImg2.png" Height="20px" OnClientClick="return Confirm()" /></td>
                </tr>
            </ItemTemplate>
            <AlternatingItemTemplate>
            <tr runat="server" style="font-family:Arial;font-size:16px; background-color:#ecffe5;border-color:transparent">
                    <td><asp:Literal ID="ltrlDate" runat="server"></asp:Literal></td>
                    <td><asp:Label ID="ltrlAmount" runat="server"></asp:Label></td>
                    <td><asp:Literal ID="ltrlDescription" runat="server"></asp:Literal></td>
                    <td><asp:ImageButton ID="btnEdit" runat="server" Text="ערוך פריט" CommandName="EditIncomeOutcome" ImageUrl="images/editBtnImg.png" Height="26px"/></td>
                    <td><asp:ImageButton ID="btnDelete" runat="server" Text="מחק פריט" CommandName="DeleteIncomeOutcome" ImageUrl="images/deleteBtnImg2.png" Height="20px"  /></td>
                </tr>
                </tbody>
                </AlternatingItemTemplate>
            <FooterTemplate>
                </table>
            </FooterTemplate>
        </asp:Repeater>    

Thanks for the help.

allan

It looks like the tbody is in side the template. move it outside. DataTables only supports a single tbody.

Allan