Repeater Control

 Ø Repeater Control:-

1. Display data in row format.

Ex:- first html changes like adding item templates and all and giving control in it         <asp:Repeater ID="Repeater1" runat="server">

                <ItemTemplate>

                    <b>

                        ROll

                    </b>

                    <asp:Label ID="Label1" runat="server" Text='<%#Eval("ROLL")  %>'></asp:Label>

                    <br/> 

                    <b> NAME</b>

                    <asp:Label ID="Label2" runat="server" Text='<%# Eval("NAME") %>'></asp:Label><br />

                    <b> CITY</b>

                    <asp:Label ID="Label3" runat="server" Text='<%# Eval("CITY") %>'></asp:Label><br />

                    <hr>

 

                </ItemTemplate>

            </asp:Repeater>  

Then the C# code is

 protected void Button1_Click(object sender, EventArgs e)

    {

        string path = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\college.mdf;Integrated Security=True";

        con = new SqlConnection(path);

        con.Open();

 

        string stl = "SELECT * FROM CONNECTDB";

        com = new SqlCommand(stl, con);

        dr = com.ExecuteReader();

 

 

        Repeater1.DataSource = dr;

        Repeater1.DataBind();

 

        dr.Close();

 

Ø REPEATER EVENT HANDLING:-

1. INSIDE :- WE have to use COMMANDNAME attribute

2. OUTSIDE:-

 

 

Ø How to activate COMMANDNAME ATTRIBUTE:- using onItemCommandEvent inside the repeater

 

            <asp:Repeater ID="Repeater1" runat="server" OnItemCommand="Repeater1_ItemCommand">

 

 

Ø Find control for repeater :-

Syntax :-

Label.objname =(label)e.item.findcontrol(“lblname”);

 

 if(e.CommandName=="DISPLAY")

        {

            // Response.Write("WELCOME");

            //find control

            Label objname = (Label)e.Item.FindControl("lblname");

 

            Response.Write(objname.Text);

 

 

        }