Chee mun Low
Chee mun Low

Reputation: 83

repeater format

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

Answers (1)

Saurabh
Saurabh

Reputation: 5727

<asp:Repeater ID="Repeater1" runat="server" DataSourceID="SqlDataSource1" >

     <ItemTemplate>
userName:&nbsp;
    <%#DataBinder.Eval(Container.DataItem, "subject" ) +"<br/>"%>
phone:&nbsp;
    <%#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

Related Questions