Reputation: 83
i am quite blur in using repeater
is that any way do not display data in first row of sql?
data inside my db
userName Phone
Admin admin
roy 012345678
ken 012345678
output from my code
userName: Admin
Phone: admin
------------------------------------
userName: roy
Phone: 012345678
------------------------------------
userName: ken
Phone: 012345678
------------------------------------
Expected output
userName: roy
phone: 012345678
------------------------------------
userName: ken
phone: 012345678
----------------------
below here is my code
<asp:Repeater ID="Repeater1" runat="server" DataSourceID="SqlDataSource1" >
<ItemTemplate>
Course Name: <%#DataBinder.Eval(Container.DataItem, "subject" )%>
<br />
Subject Info: <%#DataBinder.Eval(Container.DataItem,"subjectIntroduction")%>
<hr />
</asp:Repeater>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT [subject], [subjectIntroduction] FROM [courseSubjectTable]">
</asp:SqlDataSource>
Upvotes: 0
Views: 331
Reputation: 5727
<asp:Repeater ID="Repeater1" runat="server" DataSourceID="SqlDataSource1" >
<ItemTemplate>
userName:
<%#DataBinder.Eval(Container.DataItem, "subject" ) +"<br/>"%>
phone:
<%#DataBinder.Eval(Container.DataItem,"subjectIntroduction") + "<hr/>"%>
</ItemTemplate>
</asp:Repeater>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT [subject], [subjectIntroduction] FROM [courseSubjectTable]">
</asp:SqlDataSource>
Use this not to show admin:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT [subject], [subjectIntroduction] FROM [courseSubjectTable] where userName <> 'Admin'">
Upvotes: 1