中继器仅显示3个随机行 [英] Repeater showing only 3 random rows

问题描述

我这样从我的SQL数据库中检索数据.
这是在pageLoad()

这是大约7行

I retrive data from my SQL db like this.
This is on pageLoad()

here are about 7 rows

conn.Open();

SqlCommand cmd = new SqlCommand("SELECT * FROM Rating", conn);
SqlDataReader dt = cmd.ExecuteReader();
rptrComments.DataSource = dt;
rptrComments.DataBind();
conn.Close();

我的中继器

My repeater

<asp:Repeater ID="rptrComments" runat="server">

           <ItemTemplate>

               <ajax:Rating ID="ratingControl11" AutoPostBack="true" runat="server" StarCssClass="ratingEmpty1"

                               WaitingStarCssClass="ratingSaved1" EmptyStarCssClass="ratingEmpty1" FilledStarCssClass="ratingFilled1" CurrentRating='<%#Eval ("Rate") %>'>
                </ajax:Rating>



           </ItemTemplate>

           <AlternatingItemTemplate>
           <br />
              <%#Eval("ID")%>
           <%#Eval("Coment")%>
           </AlternatingItemTemplate>

           <SeparatorTemplate>

           </SeparatorTemplate>

       </asp:Repeater>

但这仅显示了3行，而不是我的7行.

But this showing just 3 randomly rows and not all my 7 rows, can you help please.

推荐答案

AlternatingItemTemplate:使用此属性可为交替显示提供不同的外观在ItemTemplate中指定的内容中，Repeater控件中的所有项目.
这就是微软所说的！
检查其中四个的注释和ID值是否为空！

AlternatingItemTemplate:Use this property to provide a different appearance for alternating items in the Repeater control from what is specifed in the ItemTemplate.
this is what microsoft saying!
check maybe your coment and ID value is empty for 4 of them!

<asp:Repeater ID="rptrComments" runat="server">

           <ItemTemplate>

               <ajax:Rating ID="ratingControl11" AutoPostBack="true" runat="server" StarCssClass="ratingEmpty1"

                               WaitingStarCssClass="ratingSaved1" EmptyStarCssClass="ratingEmpty1" FilledStarCssClass="ratingFilled1" CurrentRating='<%#Eval ("Rate") %>'>
                </ajax:Rating>

           <%#Eval("ID")%>
           <%#Eval("Coment")%>


           </ItemTemplate>

           <AlternatingItemTemplate>
           <br />
           <%#Eval("ID")%>
           <%#Eval("Coment")%>
           </AlternatingItemTemplate>

           <SeparatorTemplate>

           </SeparatorTemplate>

       </asp:Repeater>

尝试使用此方法...它将显示您的所有记录..

try using this...it will show your all records..

<AlternatingItemTemplate>

仅显示替代行，而不是全部..

谢谢

如果您得到了答案并且不要忘了给评分，请标记为解决方案.

shows only alternate rows not all..

Thanks

Mark solution if you got your answers and dont forget to rate...

这篇关于中继器仅显示3个随机行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！