How to Bind a repeater control in asp.net.

Repeater Control Source Code:-

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

                <ItemTemplate>

                    <asp:HiddenField ID="hdnLeaveTypeID" runat="server"Value='<%#Bind("Leave_Type_ID") %>' />

                    <table class="repeater" cellpadding="0" cellspacing="0">

                        <tr>

                            <td colspan="3" class="repeater_td_header">

                                <asp:Label ID="lblLeaveType" runat="server"Text='<%#Bind("Leave_Type_Name") %>'></asp:Label>

                            </td>

                        </tr>

                        <tr class="repeater_tr_content">

                            <td style="width: 50%; padding-left: 3%">

                                <b>Allocated</b>

                            </td>

                            <td style="width: 4%">

                                <b>:</b>

                            </td>

                            <td style="width: 40%; text-align: left;">

                                <asp:Label ID="lblAllocated" runat="server"Text='<%#Bind("Allocated_Days") %>'></asp:Label>

                            </td>

                        </tr>

                        <tr class="repeater_tr_content">

                            <td style="width: 50%; padding-left: 3%">

                                <b>Leaves Taken</b>

                            </td>

                            <td style="width: 4%">

                                <b>:</b>

                            </td>

                            <td style="width: 40%; text-align: left;">

                                <asp:Label ID="lblTaken" runat="server"Text='<%#Bind("No_Of_Days") %>'></asp:Label>

                            </td>

                        </tr>

                        <tr class="repeater_tr_content" style="background-color: #90EE90">

                            <td style="width: 50%; padding-left: 3%">

                                <b>Available</b>

                            </td>

                            <td style="width: 4%">

                                <b>:</b>

                            </td>

                            <td style="width: 40%; text-align: left;">

                                <asp:Label ID="lblAvailable" runat="server"Text='<%#Bind("Available_Days") %>'></asp:Label>

                                <asp:HiddenField ID="HdnAvailableDays"runat="server" Value='<%#Bind("Available_Days") %>' />

                            </td>

                        </tr>

                    </table>

                </ItemTemplate>

                <%-- <SeparatorTemplate>

                    <hr />

                </SeparatorTemplate>--%>

            </asp:Repeater>

Design View:

Code Behind method to bind the Repeater:-

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

            FillRepeater();

        }

    }

    public void FillRepeater()

    {

        SqlConnection con=new SqlConnection("...Your Connection String...");

        SqlCommand SelectDetails = new SqlCommand("select Leave_Type_ID,Leave_Type_Name,Allocated_Days,No_Of_Days,Available_Days From Employee_Leave_Details", con);

        DataTable dtRecords = new DataTable();

        SqlDataAdapter dap = new SqlDataAdapter(SelectDetails);

        dap.Fill(dtRecords);

        RepeaterLeaveStatus.DataSource = dtRecords;

        RepeaterLeaveStatus.DataBind();

    }

}

Output: 

Thanks

     Shibashish Mohanty