Binding a repeater in C# has duplicates

40 Views Asked by At

I have a repeater control I am trying to group this but it is showing duplicates

Here is what it is doing: enter image description here

Repeater Control

        <asp:Repeater ID="GroupRepeater" OnItemDataBound="GroupRepeater_ItemDataBound" runat="server">
            <HeaderTemplate>
                <asp:HiddenField ID="CompanyName" runat="server" />
                   
            </HeaderTemplate>
            <ItemTemplate>     
                <div id="BoardGrpName">
                    <%# Eval("BoardGroupName") %>
                </div> 
                <div id="BoardCompanyName1">
                    <%# Eval("CompanyName") %>
                </div>
                <div id="BoardCompanyName2">
                    <%# Eval("BoardMemberName") %>
                </div>
                <br />
            </ItemTemplate>
            <FooterTemplate>
                <div class="label label-light" id="BoardMemberName">                                       
                    <asp:Label ForeColor="Black" Font-Size="12px" runat="server"><%# Eval("BoardMemberName") %></asp:Label>                                                                                       
                </div>               
            </FooterTemplate>
        </asp:Repeater>   

Code Behind

 protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                if (!Page.IsPostBack)
                {
                    //load board members                    
                    GroupRepeater.DataSource = DbHelper.SqlStoredProcedureDataTable("spQueryFullBoardInfo", ConfigurationManager.ConnectionStrings["NConnectionString"].ConnectionString);
                    GroupRepeater.DataBind();
                    divMessage.Visible = false;                   
                }
            }
            catch (Exception ex)
            {
               catch error here
            }           
        }

DB from SP

I have tried many things. Moving it to the header, binding to a list but I get the same results. I am guessing it is something simple i am missing. Thanks in advance.

0

There are 0 best solutions below