A quick guide to using nested repeaters in ASP.NET

string id_continent = Session["cont"].ToString();
using (SqlConnection cnn = new SqlConnection())
{
   cnn.ConnectionString = ConfigurationManager.ConnectionStrings["zamest"].ConnectionString;
   cnn.Open();

SqlDataAdapter daState = new SqlDataAdapter("SELECT State, ID_State FROM Table_State", cnn);
//When I tried add "WHERE" in select app say error message
//SqlDataAdapter daState = new SqlDataAdapter("SELECT State, ID_State FROM Table_State WHERE ID_Continent = 1", cnn);

//Create and fill the DataSet.
DataSet ds = new DataSet();
daState.Fill(ds, "Dic");

//Create a second DataAdapter for the Titles table.
SqlDataAdapter daCity = new SqlDataAdapter("SELECT City, ID_City, ID_State from Table_City", cnn);
daCity.Fill(ds, "City");

//Create the relation bewtween the Authors and Titles tables.
ds.Relations.Add("City",
ds.Tables["State"].Columns["ID_State"],
ds.Tables["City"].Columns["ID_State"]);

//Bind the Authors table to the parent Repeater control, and call DataBind.
parentRepeater.DataSource = ds.Tables["State"];
page.DataBind();
}
}

private void Page_Init(object sender, EventArgs e)
{
   InitializeComponent();
}

private void InitializeComponent()
{
   this.Load += new System.EventHandler(this.Page_Load);
}

<asp:Repeater ID="parentRepeater" runat="server">
   <ItemTemplate>
      <%# DataBinder.Eval(Container.DataItem,"State") %>

      <asp:Repeater ID="childRepeater" DataSource='<%# ((System.Data.DataRowView)Container.DataItem).Row.GetChildRows("City") %>'
                                        runat="server">
         <ItemTemplate>
            <%# DataBinder.Eval(Container.DataItem, "[\"City\"]")%><br />
         </ItemTemplate>
      </asp:Repeater>

<asp:Repeater runat="server" ID="myrep"><br />
    <HeaderTemplate><br />
        <ul><br />
    </HeaderTemplate><br />
    <ItemTemplate><br />
        <li><b><br />
            <%#((System.Xml.XmlElement)Container.DataItem).SelectSingleNode("@type").InnerText%><br />
            <br /><br />
            <asp:Repeater runat="server" ID="cric" DataSource='<%#((System.Xml.XmlElement)Container.DataItem).SelectNodes("cricketer")%>'><br />
                <HeaderTemplate><br />
                    <ul><br />
                </HeaderTemplate><br />
                <ItemTemplate><br />
                    <li><br />
                        <%#((System.Xml.XmlElement)Container.DataItem).InnerText%><br />
                    </li><br />
                </ItemTemplate><br />
                <FooterTemplate><br />
                    </ul></FooterTemplate><br />
            </asp:Repeater></li><br />
        </b><br />
    </ItemTemplate><br />
    <FooterTemplate><br />
        </ul><br />
    </FooterTemplate><br />
</asp:Repeater>

protected void Page_Load(object sender, System.EventArgs e)<br />
		{<br />
            LinksTableAdapters.CategoryTableAdapter Cat = new LinksTableAdapters.CategoryTableAdapter();<br />
            CategoryRepeater.DataSource = Cat.GetData();<br />
			CategoryRepeater.DataBind();<br />
		}<br />
<br />
        private void CategoryRepeater_ItemDataBound(object sender, System.Web.UI.WebControls.RepeaterItemEventArgs e)<br />
        {<br />
            RepeaterItem item = e.Item;<br />
            if ((item.ItemType == ListItemType.Item) ||<br />
                (item.ItemType == ListItemType.AlternatingItem))<br />
            {<br />
                PlayerRepeater = (Repeater)item.FindControl("PlayerRepeater");<br />
                LinksTableAdapters.LinksTableAdapter myItems = new LinksTableAdapters.LinksTableAdapter();<br />
                DataRowView drv = (DataRowView)item.DataItem;<br />
                PlayerRepeater.DataSource = myItems.GetLinksByParameter(int.Parse(drv.Row.ItemArray.GetValue(0).ToString()));<br />
                PlayerRepeater.DataBind();<br />
            }<br />
        }

Table 1 ("PlayerTypes"):
PlayerType
----------
Bowlers
Batsmen
Allrounders
WicketKeeper

Table 2 ("Players"):
PlayerType   Player
----------   ------------
Bowlers      Wasim Akram
Batsmen      Geoff Boycott
Batsmen      Sunny Gavaskar
Bowlers      Michale Holding
etc.....

<asp:repeater id="PlayerTypesRepeater" runat="server">
<itemtemplate>
    <b><%# DataBinder.Eval(Container.DataItem, "PlayerType") %></b>
    <asp:repeater id="PlayersRepeater" runat="server"
            datasource='<%# Container.DataItem.Row.GetChildRows("PlayerTypesRel") %>'>
    <itemtemplate>
        <i><%# DataBinder.Eval(Container.DataItem, "Player") %></i>
    </itemtemplate>
    </asp:repeater>
</itemtemplate>
</asp:repeater>