C#

public void Customers1_ItemDataBound(Object sender, RepeaterItemEventArgs e) <br />
    {<br />
        if ((e.Item.ItemType == ListItemType.Item) || (e.Item.ItemType == ListItemType.AlternatingItem)) <br />
        {<br />
            //This is to look for the Customer2.Repeater that is nested inside the Customer1.Repeater.<br />
            Repeater oRPT = (Repeater)e.Item.FindControl("Customers2");<br />
            DataRowView oDrv = (System.Data.DataRowView)(e.Item.DataItem);<br />
            //This line is to retrieve only the records in the CTPT table that have the same ItemID as the HSCTI record in the current row.<br />
            oRPT.DataSource = oDrv.CreateChildView("<HSCTI>");<br />
            oDrv.DataView.RowFilter = "HSCTI.Status = 'Open'";<br />
            oRPT.DataSource = oDrv;<br />
            oRPT.DataBind();<br />
        }<br />
    }